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

    Ton N filters based on row grand total

    Sri K

      Hi,

       

      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..

       

      Thanks,

      Sri