Sum values from different dimensions
I need help since I could not deal with this problem by myself. I have tried different formulas but did not receive any result.
I have 3 dimensions.
Store EH02, EH 03, EH 04 etc.
Cost Center SRV 201, SRV 301, SRV 401 etc.
Departmanet IB01, IB02, IB03 etc.
I now how to define names or sum values in one dimension. For example Sum(Value, where ([store]="EH02",[store]="EH03" )
But now I need to sum values using all three dimensions. Since different combinations have different meanings.
Store EH02 and Cost Center SRV 201 and Department IB01 = customers
Store EH 02 and Cost Center SRV 301 and Department IB02 = dealers
Store EH 03 and Cost Center SRV 201 and Department IB01 = foreign customers etc.
Please help me to define variable for each of these combinations.
My table looks like
Raju Kushwaha replied
Please Used this code
=If (([Store] inlist( "EH03","EH04")) And ([Cost Center] inlist( "SRV-201","DST-201")) Then "Standart customers"
Also made variable as details of [Store] or [Cost Center] if this not work then use [Store] and [Cost Center] in column and hide them.