4 Replies Latest reply on Aug 21, 2016 1:32 AM by Prithvi I

    Grouping dynamically by SUM of Revenue

    Elberti Uiterwaal-Postma

      I have the attached data. Showing 26 clients and the revenue that they generate per month. I would like to group these clients in 3 categories <25,000, <100.000 & > 500.000. Depending on the total revenue per year a client is categorized.

       

      I would like to get a table showing:

      Year<25000<100000>500000
      2014

      No. of Clients

      Total Revenue

      No. of Clients

      Total Revenue

      No. of Clients

      Total Revenue

      2015

      No. of Clients

      Total Revenue

      No. of Clients

      Total Revenue

      No. of Clients

      Total Revenue

      2016

      No. of Clients

      Total Revenue

      No. of Clients

      Total Revenue

      No. of Clients

      Total Revenue

       

      Is this possible and if so how can I achieve this?

       

      Thanks for all your help!