Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Please help me to define variable for each of these combinations.

My table looks like

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

Former Member
Former Member replied

Hi Ofeliya,

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.

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question