Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I have a data set like below.
Customer | Cost1 | Cost2 | Revenue |
A | 10 | 30 | 100 |
B | 20 | 10 | 200 |
C | 30 | 20 | 300 |
I want to create a calculated dimension for customers based on cost1 and cost2,
i want only those customer in my calculated dimension, when sum(cost1)+sum(Cost2)>=50.
thanks
Prasanta
Alternative solution is to use a set analysis like this:
=Sum({<Customer = {"=Sum(Cost1) + Sum(Cost2) >= 50"}>}Revenue)
With Customer as the dimension
You can try this as your dimension:
=If(Aggr(Sum(Cost1) + Sum(Cost2) >= 50, Customer), Customer)
Alternative solution is to use a set analysis like this:
=Sum({<Customer = {"=Sum(Cost1) + Sum(Cost2) >= 50"}>}Revenue)
With Customer as the dimension