Calculate dimension

[#1]

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

[sunny_talwar]

You can try this as your dimension:

=If(Aggr(Sum(Cost1) + Sum(Cost2) >= 50, Customer), Customer)

[sunny_talwar · Accepted solution]

Alternative solution is to use a set analysis like this:

=Sum({<Customer = {"=Sum(Cost1) + Sum(Cost2) >= 50"}>}Revenue)

With Customer as the dimension