2 Replies Latest reply on Jan 19, 2018 3:01 AM by Jyothisree Rayagiri

    Top 25 Clients?

    Rahul Kumar

      Hi All,

       

      I have data for date, client, company type and Calculated value. Date filed gives month over month data. Company type is of two types- Private and Public. Each Client has a calculated Value for a date.

       

      I need to show

      1. The Top 25 Private clients for each month - which includes period, client name and calculated value info in a cross-tab.
      2. Sum of top 25 private clients Calculated value, Total Sum of private clients Calculated value and difference of  (Total Sum of private clients Calculated value - Sum of top 25 private clients Calculated value).

       

      Is there any calculation which gives the sum of top 25 private clients value for each month?

       

      Please find the attached sample workbook which I'm working on.

       

      It would be great if someone can help me out.

       

      Thank you.

       

      Regards,

      Rahul.