Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.