0 Replies Latest reply on Nov 12, 2012 8:43 AM by N A

    Percent of Total Calculation

    N A

      Hi,

       

      I am trying to calculate the % of total based on each customer’s number of orders and display that at aggregate level.

       

      What I want to display is:

       

      (Between Order Date 7/1/2010 – Order Date 7/4/2010)

      Store ID

      Number of Total Customers

      Number of Total Orders

      % of Customers with 1 Order

      % of Customers with >1 Orders

      % of Customers with >2 Orders

      % of Customers with >3 Orders

       

      I attached a packaged workbook.

       

      Thanks in advance for your suggestions.