Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I'm trying to get pivot table comparsion between main and some others alterstates.
In the following example i've got the solution. But variance to Dim1 to Dim1 anyway is zero. So i lookin the way to hide it.
In the second chart i excluded Dim1 variance but Dim2 variance cannot be calulated in this try.
Please help to get correct solution which will exclude Dim1 variance in a correct way
Hi!
Try move supression of Dim1 from Dimention to expression, like:
IF( Dimensions <> 'Dim1'
,sum({AS1+AS2}Value)
)
Good, but not target solution.
Variance Dim1 vs Dim1 isnt hided.
N
What does it means?
No one answer?
Currently we r lookin' for answer.
Please help.
Sorry must have caught the key board whilst reading the questions.