#pivottable

Hello everyone, I have pretty straight forward question, but just can't get it to work. I want that conditional formatting is applied to the column range only, in Pivot table (and when the pivot table column range shrinks or expands due to changes in the main document that formating is only...

* how to Apply Condition Formating in Particular Cells At a time, (Condition : IF then " Available Qty " <1 to Highlight Cell is RED color). * This condition Apply but Not properly Working , Pleased help to solve this query, I try to use Multiple criteria using this condition formatting.

Hello, The count function in a pivot table counts all fields with a formula, even if the formula returns blank. Is there a way to create a calculated field that only counts the cells with Text in them. In the example below, there are 30 Rows, but only 9 are COMPLETE. The standard count...

Can a pivot table calculate two items under one category? Here's an example of what I want to do. I've provided a table of what I want the pivot table to look like when it's calculating the data. I don't know how to add/include actual excel cells into my message so I apologize about that...

Hi I need some help setting up a pivot table. I need to compare sales figures from 2 seperate years for example sales figures from week 1 2016 against sales figures for week 1 2017 for each store. I then need to be able to show the monetary difference between each year and the % difference...

Hi, I was wondering if someone could please help me with the creation of a simple Pivot table for a research project? Please message me. Thanks. ?

I need to 1. Find the MAX of students on 2 variables. (course and country), 4 countries x 3 courses, so there are 12 MAX answers. 2. Filter the data to only include dates in say 2015 using a "timeline" slicer (not all) 3. SUM the results of step 1 filtered by step 2, this time...

Through Excel, is there anyway to join two pivot tables that have separate data? If so, please provide steps.

I have two databases from two different sources, I created a pivot table to summarize the data. Then, I copied and pasted values to a new worksheet for sales by cost centers. First, I noticed that there was missing cost centers from one of the databases. I need to compare these two lists to...

Hi Forum, Trying to create a combo box that auto filters a cube generated pivot table. My code is provided below, but breaks at line 4. For some reason, the PT filter can't read the cell value in A54. Any help is greatly appreciated. Sub StateChangeTest()...

The Data I am pulling from is:<o:p></o:p> <o:p></o:p> <tbody> ATA<o:p></o:p> Claim Amount<o:p></o:p> # Units<o:p></o:p> 11/7/2010<o:p></o:p> $322.89<o:p></o:p> 4<o:p></o:p> 3/29/2011<o:p></o:p> $41.36<o:p></o:p> 24 (4 ctns)<o:p></o:p> 3/4/2011<o:p></o:p>...

The Data I am pulling from is:<o:p></o:p> <o:p> </o:p> <tbody> ATA<o:p></o:p> Claim Amount<o:p></o:p> # Units<o:p></o:p> 11/7/2010<o:p></o:p> $322.89<o:p></o:p> 4<o:p></o:p> 3/29/2011<o:p></o:p> $41.36<o:p></o:p> 24 (4...