8 Replies Latest reply on Mar 14, 2017 5:17 AM by Dhruv Gupta

    Ton N filters based on row grand total

    Sri K



      I want to display top 5 values And rest of the values should display as "others" in each segment


      Can anyone help me how we can achieve this. Attaching sample twbx file..


      For Example:

      In the below screenshot is the example, i want to display top 5 sub category for each segment and want to display all subtotals and grand totals. remaining all subcategories should show as others.


      Using 9.3 version..