Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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 !!
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" ?
Hi,
Go to the presentation tab, click on each dimension and click on subtotal on top or Bottom.
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