Sub Total for each Measure per each Dimension

[#1]

Hi , I need to create a Pivot Table where i am using 4 Dimensions and and Three Expressions (Sales,Members,Revenue)

Among the Last dims are Year and Month and i have brough them to the Top Horizontal , now i need to to show the Total Sum of each expression for all the months in a year and also per year.

Please find the attachement for your reference!!

Can you please help me on this issue

[#2]

Hi Jonathan,

Please check the attached Excel for your understanding of "My Requirement" and "Qlikview Output" when i select show partial sums for Year and/or Month

Thanks,

Santosh

[#3]

Hi Jonathan,

Please check the attached Excel for your understanding of "My Requirement" and "Qlikview Output" when i select show partial sums for Year and/or Month

Thanks,

Santosh

[#4]

Hi,

OK convinced the others that there is an alternate way of achieving this and had dragged the Year and Month  columns on to the Y-axis and enabled the SubTotal and which is working fine .

Thanks for the help guys !!

[#5]

Hi Jonathan,

Is it possible to display the Month related subtotal Label name for that year ?

like for 2014 year as "2014 Total" and 2015 as "2015 Total" ?

[#6]

Hi,

Go to the presentation tab, click on each dimension and click on subtotal on top or Bottom.

[PrashantSangle]

Hi,

Consider you are using Year , Month as dimension.

Then drag your Month Field below Expression field and go to presentation and select Month ->show Partial Sum

Regards