topic Re: MULTIPLE YEARS TOTAL in QlikView

MULTIPLE YEARS TOTAL

Mon, 14 Jul 2014 21:28:51 GMT

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

Re: MULTIPLE YEARS TOTAL

jaimeaguilar — Tue, 15 Jul 2014 02:42:05 GMT

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

Re: MULTIPLE YEARS TOTAL

Tue, 15 Jul 2014 06:19:35 GMT

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