MULTIPLE YEARS TOTAL

[#1]

Please see the attached file . this is a Pivot Table with dimensions as State and Year. In Totals I wanna list the Totals for Year 2013 and 2014

I have created another table right below it to Cheat, but it would be nice if it can be accomplished in one Table. any Help is appreciated

[jaimeaguilar]

Hi,

maybe re-arranging your pivot table could give you better results within a single table. Take a look at the examples where you can achieve totals/subtotals using calculated dimension, subtotals property or an additional expression

regards

[#3]

Hi RAY,

You can achieve the same by promoting the As_Of_Year Dimension to top

if your pivot table is not expanded the it will show the Revenue for only 2013 and 2014,

Regards,

Vivek