Récupérer la valeur d'une dimension dans un tableau

[#1]

Hi everybody,

I would like to know if there is a way to find the value of a dimension in a table. I'm used to do it with column(x) for expressions but this function doesn't work with dimensions...

Someone knows a way to find the value of a dimension?

Thank you for your help

Augutsin

[alexandros17]

What do you mean with value of dimension? can you detail more?

[#3]

This is an exemple of what i want

I want to replace "TOP", "BOT", "Other" by something that can automatically find the value in departement.

Dimension	Dimension	Expression	Expression
Country	Department	Turnover Country	Turnover World
France	TOP	2500	sum({1<Departement = {TOP}>} Turnover)
France	BOT	5000	sum({1<Departement = {BOT}>} Turnover)
France	Others	7500	sum({1<Departement = {Other}>} Turnover)

Am I clear?

[alexandros17 · Accepted solution]

I think that if you write

Sum({1} Turnover) for the three expression you will get the same result because Sum is performed for each dimension so is made for combination France-TOP, France-BOT and so on.

Let me know.

[#5]

As Allesandro said, you don't need to specify the value of the column Department as you have the dimension but you need to specifiy you don't to take in account the country so you might do something like

sum({1<Country= {*}>} Turnover)

so the sum will operate without coutnry but slicing it by department.

[#6]

You are right, it was that silmple. Thank you both of you