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

       

      Regards,

      Michael 

        • 1. Re: Need summary
          Tracy Rodgers

          Hi Michael,

           

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

           

          window_sum([Formula])

           

          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!

           

          -Tracy