3 Replies Latest reply on Oct 31, 2018 10:40 AM by Ritesh Bisht

    Aggregated counts by Top 10, Next 20 and Remaining

    Sank Y

      Hi All,
      We are trying to achieve aggregated numbers by Top 10, Next 20 and remaining members. Tried using table calculations index(), rank(), sets etc. but it does not seem to work. Trying to achieve something similar to below crosstab using Superstore dataset to display sales by states and ranks.

       

      Thanks in advance.

       

      # of StatesSales(% of Total)
      Top 10101,588,70969.2%
      Next 2020602,00326.2%
      Remaining19106,4884.6%
      Total492,297,200

      100%