Is this possible in Pivot table?

[Guest]

Is it possible to create a report in the following format with a Pivot Table?

Jan Feb Mar % diff in last 2 months displayed
Item1 100 100 125 25%
Item2 100 100 110 10%
Item3 110 100 90 (10)%

I could then select to display only Jan and Mar and the % diff would display
between those 2 months.

 

[Bernie Deitrick]

To do it automatically, you would need to show % difference from previous month for all three
months: your table would look like:


Month Data
Jan Feb Mar
Item Sum of Value Sum of Value2 Sum of Value Sum of Value2 Sum of Value Sum of Value2
Item1 100 100 0.00% 125 25.00%
Item2 100 100 0.00% 110 10.00%
Item3 110 100 -9.09% 90 -10.00%



To only show the last month, you would need to set up a column of formulas, which would be a problem
when you update the PT.

HTH,
Bernie
MS Excel MVP