Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Accumulated sub-totals in a pivot table

Hi

I want to know if it's even remotely possible to put in an accumulated total in a pivot table for each section so that it looks like the layout below:

GroupRankSTORESales ValueSales Units
51ABC Retailers2 500 000200 000
2DEF Retailers2 450 000180 000
3GHI Retailers2 350 000175 000
4JKL Retailers2 300 000170 000
5MNO Retailers2 250 000165 000
Total 11 850
  000
890 000
Accumulated Total 11 850
  000
890 000
106PQR Retailers2 200 000160 000
7STU Retailers2 150 000155 000
8VWX Retailers2 100 000150 000
9YZA Retailers2 050 000145 000
10BCD Retailers2 000 000140 000
Total 10 500
  000
750 000
Accumulated Total 22 350
  000
1 640 000
1511EFG Retailers1 950 000135 000
12HIJ Retailers1 900 000130 000
13KLM Retailers1 850 000125 000
14NOP Retailers1 800 000120 000
15QRS Retailers1 750 000115 000
Total 9 250 000625 000
Accumulated Total 31 600
  000
2 265 000
2016TUV Retailers1 700 000110 000
17WXY Retailers1 600 000105 000
18ZAB Retailers1 500 00095 000
19CDE Retailers1 000 00070 000
20FGH Retailers500 00035 000
Total 6 300 000415 000
Accumulated Total 37 900
  000
2 680 000

Sorry it doesn't look all that great but I had to do a mock-up in excel to show you what I am looking for. Has anyone been able to do this before?

Thanks

Colleen

Community Browser