0 Replies Latest reply: Jun 6, 2013 9:14 AM by Colleen Cross RSS

    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