software

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.

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 MVPquot;ABMquot; gt; wrote in message
...
gt; Is it possible to create a report in the following format with a Pivot Table?
gt;
gt; Jan Feb Mar % diff in last 2 months displayed
gt; Item1 100 100 125 25%
gt; Item2 100 100 110 10%
gt; Item3 110 100 90 (10)%
gt;
gt; I could then select to display only Jan and Mar and the % diff would display
gt; between those 2 months.