Regarding Top 10 in Pivot

[sarfaraz_sheikh]

Dear All,

I used rank() in expression defination for calculating top 10...and i got that but how i can suppress other value in expression field other than top 10 in pivot table.

below is my expression :-

=if(Rank(Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO)) <=10,Count( {<SUB_VERTICAL_DESC={'AUTO'} >} SI_NO))

Screeshot and QVW is also attached here for your reference

Kindly help !!!!

Regards

Sarfaraz

[ashfaq_haseeb]

Hi,

I don't find any such issue.

have a look at attached image and application

Regards

ASHFAQ

[sarfaraz_sheikh]

Dear Ashpak,

I dont know why it is showing at my end.........anyway how i can suppress them any clue/solution/suggetion from your side

Sarfaraz

[marchoctober]

Hi!

Why don't you use Calculated Dimension? Calculate what do you want in it, so it should help.

[Anonymous]

Take a look at the attached file.

Is that what you are looking for?

Dennis.

[richard_chilvers]

I haven't looked at your issue in detail.

But do look at the Dimension Limits tab which can be useful to do Top n or Bottom n etc....

[Anonymous]

There is Dimension Limits tab in a pivot object I think.

[sarfaraz_sheikh]

Dear Dennis,

once i click on the particular Disp_Catogory ...then it appears correct count order as top 10 but when i unclick the same then it appears in diffrent count..

Look on the snapshot below:---

[sarfaraz_sheikh]

Dear Richard,

There is no Dimesion limit Tab in Pivot table ..........I checked in that

Sarfaraz

[jzimolong]

I'm struggling to figure out what your final desired output looks like.  I came up with same thing as Dennis, using a calculated dimention for INTERMD_NAME, secondary to DISP_CATEGORY.

are you looking for final result like the attached?