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

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

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?

• ###### Re: How to use calculaed dimension or bring TOP 10 dimension limit in PIVOT Table

you can use Rank function to show the top n values,

If(Rank(Count(Ticket)<=10,Rank(Count(Ticket))

• ###### Re: How to use calculaed dimension or bring TOP 10 dimension limit in PIVOT Table

create expression

=Count({<[IT Team] ={"=rank(count(Ticket),4)<=10"}>}Ticket)

• ###### Re: How to use calculaed dimension or bring TOP 10 dimension limit in PIVOT Table

Vijay,

use below calculated dimension

=if(aggr(rank(count(Ticket #)),IT Team)<=10,IT Team)

it will first calculate the count of Tickets,

then aggregate it based on IT team,

then compare it with 10 (top 10)

then display the IT Team as dimension.

• ###### Re: How to use calculaed dimension or bring TOP 10 dimension limit in PIVOT Table

See attached -