check if a dimension is expanded or not

[ali_hijazi]

Hello

I got a pivot table whith two dimensions Country and Business Type

I have an expression to show

this expression depends on whether the Country is expanded or not

I'm using in my expression if dimensionaltiy() > 1, do something, else do something else)

the values are correct but the totals are incorrect

I'm thinking of putting two expressions but check the conditional check box , so as one expression shows if the country is collapsed and another if the country is expanded

Please advise

[chematos]

If you use that condition, you need to calculate the total in the section 'Else'. Without more details of the expression and what you need to calculate I can´t help you.