Pivot table - Expression visibility

[googel84]

Hi, I created a pivot table that has some dimensions vertical-wise and two dimensions horizontal-wise.

The target is to hide Fatt. (pz) only when Anno is 2011 and Mese is 'dic'.

I don't think it is feasable, to be honest, as I think you can only govern the expression overall visibility.

Any ideas?

Thanks

[vishsaggi]

Hi Alberto,

Could it be possible to share some sample application here ??

In expression tab you have a conditional check box to give a condition for that specific expression field. Need little more information on this.

Thanks,
V.

[deec]

set analysis Operators

Sum({$ - $<Anno={2011}> * $<Mese={'dlc'}>} Amount)

That should give you everything except the intersection of 2011 and dlc. If you added parenthesis it would look like this: but they're not needed because of order of operations on Set operators.

Sum({$ - ($<Anno={2011}> * $<Mese={'dlc'}>)} Amount)

[googel84]

Hi, thanks for your reply. For some reasons I cannot reply and attach at the same time, even with advanced editor...

I was already aware of the Enable option and relevant condition and it does not represent a solution to the problem as it lets you define a condition to enable or disable your expression as a whole. I mean, it lets you hide Fatt. (pz) from the whole pivot table, not from only a portion of it.

Thanks anyway.

[vishsaggi]

Try this.

[vishsaggi]

Hello Alberto,

Did you try that, did it solve your issue?

[vinieme12]

I don't think suppressing an expression for a particular dimension value is possible.

[googel84]

No, this way you are hiding Fatt. (pz) (every occurrence of it) when only dic-2011 is available.

This is not the target.

[vinieme12]

This is not possible in a Pivot table

[deec]

Alberto, did this end up working for you? It worked for me on first try.

The original chart had many Anno and Mese values shown in a pivot

After using that set analysis on the expression, no values are returned for the intersection of 2011 and dlc, so that expression is hidden ONLY in that intersection.

hidden is not really the right word... it's just not there because the expression is set to ignore all the values.