How to Show Top 10 Values in Pivot Table

[SatyaPaleti]

Hi Friends,

Attached is the data I have.

Description, Item & Inventory are the Dimensions

Cost,Current Cost,Qty & Current Qty are the fields I have to use in Expressions.

I want to show top Ten Values(Cost,Current Cost,Qty & Current Qty) in Pivot Table by Description,Item

How Can Resolve this issue?? Can any one help me in this

Thank You, Satya Paleti

[Chanty4u]

Use that fields as dimensions,

and use dimension limit value as 10 as largest or smallest watever u want.

Hope this helps you

thank you

Suresh chanty

[SatyaPaleti]

In Pivot table there will be no option 'Dimension Limits' Suresh Thank you, Satya

[Gysbert_Wassenaar]

See attached example.

If you want the items that are in the top 10 cost or in the top 10 current cost or ... etc then use expressions like sum({<Item={"=rank(sum(Cost))<11 or rank(sum([Current Cost]))<11 or rank(sum(Qty))<11 or rank(sum([Current Qty]))<11"}>}Cost)

[SatyaPaleti]

Hi,

@gwassenaar‌

Thank you for Advice. I want to show total also but I unable to get that and we have to include Inventory also in the dimension

This report should have expand and collapse by Inventory.

Thank you,

Satya

[pratap6699]

if(aggr(rank(sum(cost) and sum(quantity) and sum(currentcost)>10,item,inventary)))