12 Replies Latest reply: Jun 4, 2014 6:53 AM by Eduardo Sommer

# Pivot table

hi i am trying to to display the top 10 highest number of values which is in the pivot table is there any way that i can do this. i have attached an image of the pivot table.

can some one plz help me much appreciated..

• ###### Re: Pivot table

You can change the expression, from Count(src) to if(rank(Count(src)<11,Count(src))

Eduardo

• ###### Re: Pivot table

sorry this is not working i am getting an empty table

• ###### Re: Pivot table

Another possibility is to change from pivot table to straight table (considering you have oly one dimension in your table) and check 'Restrict which values are displayed using the first expression, in Dimension Limits tab of the properties of the straight table. Also set 10 as  the largest n Values and unmark the Show Others option in the same tab.

Eduardo

• ###### Re: Pivot table

this gives me the correct answr but i am getting a total count on the 1st row i dnt want that count :/

• ###### Re: Pivot table

In the expression tab mark No Total for your expression.

Eduardo

• ###### Re: Pivot table

can u share ur qvw file?

• ###### Re: Re: Pivot table

try this in pivot table =if(rank(Sum (src))<=10,sum(src),0)

• ###### Re: Pivot table

hey this worked but the correct one is =if(rank(Count (src))<=10,Count(src),0)

thank you so much for your help

• ###### Re: Pivot table

is there any possible way of displaying the average next to each count??

• ###### Re: Re: Pivot table

for calculating avg I sud see ur datamodel m not sure what ur src is

• ###### Re: Re: Re: Pivot table

this a test attachment hr i want to show a percentage next to the value column in the table

• ###### Re: Pivot table

Hi Shalani,

Try this:

=aggr(if(Rank(sum(Investment))<=10,Investment),Investment) (For calculating Top 10)

Thanks,

AS