5 Replies Latest reply: Sep 24, 2012 11:08 AM by whiteline _ RSS

    Partial sum on pivot table not showing grand total

    Chirag Chhatralia

      Hi,

       

      I am trying to show subtotals on a pivot table I have and the subtotal's appear to work however the grand total is coming to zero.  I'm not quite sure what or where I am going wrong.

       

      Can anyone shed any light please?

       

      Many thanks in advance.

      C

       

      Country Stock Class Stock on Hand Allocated Stock Stock On Order Stock Balance
      UK CARR 293.87 42.36 0.00 251.51
      FITTINGS 637108.42 8357.22 20602.59 649353.79
      HOSE 734902.11 7691.85 7086.11 734296.37
      OVERHEAD CHARGE 15507.89 0.00 4898.58 20406.47
      SUNDRY 0.00 0.00 0.00 0.00
      0


      Total 1387812.29 16019.79 32515.64 1404308.14
      Germany FITTINGS 314274.48 348.65 5633.55 319559.39
      HOSE 147646.84 180.01 8250.71 155717.55
      OVERHEAD CHARGE 0.00 0.00 0.00 0.00
      0 0.00 0.00 0.00 0.00
      Total 461921.33 528.65 13884.26 475276.94
      0 0


      0


      Total


      Total