orders above 100k of top 5 customers

[ilanbaruch]

hi all

in my model i have a pivot table with 4 dims. and 1 expression , i would want to sum in the expression 

only the orders above 100k of the top five customers.

any ideas ?

advanced thanks

[Claudiu_Anghelescu]

Try using Dimension Limits.

[shiveshsingh]

You can define it in Dimension Limits tab

[ilanbaruch]

hi, there is no Dimension Limits in a pivot object..

[dapostolopoylos]

Check out the attached document, i believe it will be helpful