# 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

Monhes | Store | Cost center | Department | Amount |
---|---|---|---|---|

January | EH02 | SRV 201 | IB01 | 500 |

January | EH02 | SRV 301 | IB01 | 100 |

January | EH03 | SRV 201 | IB02 | 500 |

January | EH03 | SRV 301 | IB03 | 450 |

January | EH02 | SRV 301 | IB02 | 300 |

February | EH01 | SRV 201 | IB02 | 200 |

February | EH02 | SRV 201 | IB02 | 400 |

February | EH05 | SRV 301 | IB03 | 200 |

##### Raju Kushwaha 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.