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?