7 Replies Latest reply on Feb 24, 2017 12:37 PM by m jk

    regarding totals and subtotals , need help ?

    m jk

      hi,

       

      trying to understand the concept of total and subtotal with regards to average or sum.

       

       

      version 10.0

       

      sheet 8

       

       

      for this data

      Order Date Order Date Order Date Order Date
      Product Category 2010 2011 2012 2013
      Furniture 5,973 9,428 10,844 2,706
      Office Supplies 2,836 422 632 3,423
      Technology 254 4,362 2,392 2,695
      Grand Total 2,910 3,619 3,273 3,160

       

       

      avg (sales) for last column is showing 3160 , but 2706+3423+2695 =8824/3 =2941 but showing as 3160

       

       

      sheet 6:

      and for this data
      result for avg sales
      orderdate orderdate orderdate
      Sno 2010 2011 2012
      CCC 300.0 400.0 500.0
      XXX 100.0 100.0 100.0
      YYY 200.0 200.0 200.0
      Grand Total 200.0 233.3 266.7

      last column : 500+100+200=800 and 800/3 =266.7

       

       

      same scenario but grand totals are different ?  why  avg sales are different.

       

      can some one explain here clearly how it is calculating at  database level ?

       

      as per this website , Customizing Grand Totals – Part 1 | Drawing with Numbers

       

      Jonathan Drummey