Pivot Tables: multiple 'Difference From' not shoing in subtotals

[vbavirgin]

I have a pivot table which shows 'Season' as rows and 'year', 'week, and 'channel' in columns. The value is 'sales'.

I have created 3 'difference from' fields. Year vs year value, year vs year % and week vs week %.

This works perfectly for each channel by year and week but the subtotals for week and year only show the 'difference from' for week vs week% (as it is the last in the list of values).

Anyone know how I can get all 3 to show in the subtotal?

 

[awoohaw]

Maybe you can create a measure in Power Pivot? If you can post a mini workbook of the underlying data using the xl2bb add in (link below) someone can give you an example?