Total qualifier for all dimension but one

[Anonymous]

Hello,

I have a pivot table, and I want to create an expression that dont take into account all the dimension but one.

How I can get it?

Thanks in advance,

Sara

[sunny_talwar]

Not entirely sure what you are looking for, do you have a sample you can share?

[tresesco · Accepted solution]

Try like:

Sum( Total <FieldName> Sales)

[jyothish8807]

Hi Sara,

Try to make the expression independent of the dimension.

For example:

If your Dimensions are Dim1 and Dim2. Then while creating the expression (i believe set analysis), try like below:

Exp: sum({<Dim1=>}Sales)

It would be easy to help, if you can share an example with us.

Regards

KC

[Anonymous]

It works, Thanks!