Search
Search

# Sum values from different dimensions

Hi everyone

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.

For example

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.

My table looks like

MonhesStoreCost centerDepartmentAmount
JanuaryEH02SRV 201IB01500
JanuaryEH02SRV 301IB01100
JanuaryEH03SRV 201IB02500
JanuaryEH03SRV 301IB03450
JanuaryEH02SRV 301IB02300
FebruaryEH01SRV 201IB02200
FebruaryEH02SRV 201IB02400
FebruaryEH05SRV 301IB03200

Hi Ofeliya,