12 Replies Latest reply: Nov 11, 2014 6:49 PM by David Young RSS

    Pivot table Grand Total Question

    David Young

      I have created the following command to give me an average for each of my nine shops:

       

      avg(aggr(sum({$ <TrnsDateYear={2013}>} Quantity)/count({$ <TrnsDateYear={2013}>} WorkOrderID),Shop,TrnsDesc))

       

      This works perfectly.  What I want to do now is create an avg of these 3 shops.  So if:

       

      avg(aggr(sum({$ <TrnsDateYear={2013}>} Quantity)/count({$ <TrnsDateYear={2013}>} WorkOrderID),Shop,TrnsDesc)) produces:

       

      Carp - 1.20

      Elec - 1.15

      Plumb - 1.16

       

      I want to see following:

      Carp - 1.20

      Elec - 1.15

      Plumb - 1.16

      Avg Total - 1.17

       

      Can I do this in one pivot graph?

       

      Thanks,

      David