1 Reply Latest reply on Sep 12, 2012 9:26 AM by Tracy Rodgers

    Need summary

    Michael Sonu

      I have fixed the fomruals with the help of Tracy. But i would like to have the summary by party. Any help would be highly appreciated.


      I would like to see the total sales by party


      e.g - Ansh- 3

              Mike -6




        • 1. Re: Need summary
          Tracy Rodgers

          Hi Michael,


          To get the desired result, create a calculated field similar to the following:




          Then, place this on the view. Right click on it and select Edit Table Calculation...Choose Advanced for Compute Using. Place all fields in the Compute Using box in the following order: PARTY, Order #, Day of Timestamp, Type. Choose Field: Number of Records, Sum, Ascending, click OK.


          Then, choose Deepest for at the level, and Party for Restarting every.


          Hope this helps!