AGGR calculated dimension

[ilanbaruch]

hi all

in my model i have a straight table that i would want to use with a calculated dim,

that will show only customers that their total sales amount is above 100

any ideas ?

advanced thanks

[Anil_Babu_Samineni]

Try this?

Aggr(Sum(sales)>100, Dimension)

[tresB]

You might not need aggr or calculated dimension. You could try using set analysis like:

Dimension: Customer

Exp :

Sum({<Customer={"=Sum(Sales)>100"}>}Sales)