Get Row Sub total in Pivot Table - Qlik Community

Anonymous · ‎2017-12-04

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	Q1 Total	Apr	May	Jun	Q2 Total	Grand Total
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.

Anil_Babu_Samineni · ‎2017-12-04

Will surely work for you if you provide sample QVF file

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

luismadriz · ‎2017-12-04

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