Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this?
Aggr(Sum(sales)>100, Dimension)
You might not need aggr or calculated dimension. You could try using set analysis like:
Dimension: Customer
Exp :
Sum({<Customer={"=Sum(Sales)>100"}>}Sales)