2 Replies Latest reply on Jul 17, 2012 3:46 AM by . Pinongs

    Grand Total and Monthly Average

    . Pinongs

      Hi,

       

      Is there a way to combine Grand Total (sum of all the values) and Monthly Average on the same worksheet? Thanks in advance.

        • 1. Re: Grand Total and Monthly Average
          Tracy Rodgers

          Hi Pinongs,

           

          This can be done by creating a calculated field similar to the following:

           

          total(sum([Order Quantity]))/total(countd(month([Order Date])))

           

          Hope this helps!

           

          -Tracy

          • 2. Re: Grand Total and Monthly Average
            . Pinongs

            Hi Tracy,

             

            Thank you for your quick response. The computation does work in TDE and SQL Server but not in Excel as data source (though this is fine since we will be using a database) -- I think count distinct is not an available function when connecting to Excel.

             

            On the display side, I may be missing something, is there a way to display the average in between March and Grand Total or after the Grand Total? Thanks again.