4 Replies Latest reply on May 21, 2012 3:27 PM by Craig Mullins

    i need to create bins of total sales (not based on each transaction size) by customer

    Craig Mullins

      the calculated field i created segregates by each transaction size not by the total sales for the period for each customer. how do i sum the sales by customer first and then have the bin group by total sales for the year or month.

      my file has 7,000,000+ rows, so instead i have attached a very simple example data file.

       

      i am sure there is a simple step i am missing.

      thanks