5 Replies Latest reply on Jan 11, 2017 12:08 AM by Norbert Maijoor

    How to group the Top N and Others in one Table

    YIXI ZHANG

      I have a sales ranking by "product Sub-category" , and I want need to show 3 row in the table, one row show Top N of 'Product Sub Category' sales subtotal, and second row show the "Others" subtotal, the third row show the Grand Total.

      The parameter N can be used to enter the Top N by report users.

       

      RankTotal
      The Top N14053
      Others2355
      Grand Total16408