4 Replies Latest reply: Oct 7, 2015 4:10 AM by Digvijay Singh RSS

    How to use calculaed dimension or bring TOP 10 dimension limit in PIVOT Table

    Vijay Kumar

      Hi Friends, We have the dimension limit in Charts but I dont see an option to limit dimension (TOP 10) in PIVOT Table object.


      I have 2 columns as below.


      1. IT Team

      2. Ticket #


      I am having a PIVOT Table which will show us IT Team and Count of Tickets as below.


      IT Team A = 200

      IT Team B = 300

      and so on...


      But the PIVOT Table shows the complete list. is there a way to create the PIVOT table to show only TOP 10 IT teams based on count of tickets handled?