6 Replies Latest reply on Mar 15, 2017 2:46 PM by Joe Mako

    Subtotals are not getting populated correctly when using Rank or Index functions

    Nakul Bhadoria

      Prashant Sharma

       

      Hi,

       

      I am trying to get the sub totals working correctly when trying to calculate Top N in the sub category using rank or Index functions.

       

      e.g. I will take the example for super store data set, what I am trying to achieve is to get top N product names with in each region and their sub and grand totals. I am able to dynamically filter out top n for each region the only issue is rank and index functions does not apply to grand and sub totals.

       

      Is there a way I can achieve the same.

       

      Regards,

      Nakul