Pivot comparsion main and others alterstates

[vmusolov]

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

[#2]

Hi!

Try move supression of Dim1 from Dimention to expression, like:

IF( Dimensions <> 'Dim1'

  ,sum({AS1+AS2}Value)

)

[vmusolov]

Good, but not target solution.

Variance Dim1 vs Dim1 isnt hided.

[#4]

N

[vmusolov]

What does it means?

[vmusolov]

No one answer?

[vmusolov]

Currently we r lookin' for answer.

Please help.

[#8]

Sorry must have caught the key board whilst reading the questions.