2 Replies Latest reply on Aug 16, 2017 7:02 AM by Norbert Maijoor

    Where are my Top N are from.

    Nipun Boonyavanich

      Hi,

       

      So, I can find my top N customers. However I would like to know where are they from, e.g. states, in term of how many top N customers are in each states, and how much sale do I make.

      For example, from top 100 customers.

      They are 20 from Boston which have 100,000 in total sales

      19 from New York which have 90,000 in total sales

       

      I also have a question about Grand Total. It seems to show grand total of all sales not only those filtered top N.

       

      Thank you