Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Can we get Sub total for the pivot table in qlik sense.
Example:
Q1 | Q1 Total | Q2 | Q2 Total | Grand Total | |||||
Country | Jan | Feb | Mar | Apr | May | Jun | |||
France | 1 | 5 | 6 | 12 | 3 | 1 | 3 | 7 | 19 |
Janpan | 2 | 5 | 5 | 12 | 5 | 2 | 6 | 13 | 25 |
Canada | 4 | 2 | 6 | 12 | 6 | 5 | 9 | 20 | 32 |
Please help me how to get sub totals and grand totals.
Thank you in advance.
Will surely work for you if you provide sample QVF file
Hi,
In the Pivot Table, your row will be Country and your columns will be first Quarter then Month, then in each Column turn on Totals,
I hope this helps,
Luis