How to Show top 10 Minimum Values in Pivot table

[SatyaPaleti]

Hi Friends,

Attached is the Data I have.

I am Using Fields Description, Item & Inventory as  Dimensions and Rest of the Fields Cost, CurrentCost, Qty & CurrentQty  using In Expressions

Actually Field (Cost) have Negative Values.

My Question is I want to show Field(Cost) in lowest to highest that is top 10 negative values  in PIVOT TABLE

How Can It will be Resolve. Can any one help on this

Thank you,

Satya Paleti.

[avinashelite]

If(Aggr(Rank(-Sum(Cost)) <= 10,your_required_Dimension),your_required_Dimension)

[qlikmsg4u]

Satya,

PFA