Top 10 using an expression

[#1]

I have created a pivot table with one dimension and multiple expressions.  I need to create 2 more tables using the same information but I only want to pull the top 10 and the top 10 bottom based on one of the expressions.

Here is what the expression looks like:

if (sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'}>}(SALES_OVR))<>0,

1-((sum({<FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)}>}(SALES_TOTAL))/sum({<FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)}>}(QTY))*Column(3)) /

((sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'}>}(SALES_OVR))/sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'}>}(QTY_OVR)))*Column(3))),

1-((sum({<FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)}>}(SALES_TOTAL))/sum({<FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)}>}(QTY))*Column(3)) /

((sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'}>}(SALES_TOTAL))/sum({<FYEAR={$(vBenchYr)},QUARTER={'Q4'}>}(QTY)))*Column(3))))

Is there a way to only pull the top 10 & bottom 10 based on the value from this????

[giakoum]

Dimension limits

[giakoum]

[#4]

It is an expression that I am trying to use & not a dimension.

[giakoum]

this shows the dimensions that correspond to the top 10 expression values

largest 10 values means largest 10 expression values

[#6]

How do I get this tab to show???? I don't see dimension limits tab

[giakoum]

what chart type do you use? it is not available for all

[#8]

Pivot table and also my dimension is set up as a group

[ramoncova06]

do you want the top 10 and min 10 inside of the same expression ?

[#10]

Not in the same expression.