Pivot table with many expressions - problem with a total

[#1]

Hi everyone!

I have a pivot table with 2 dimensions (Types and Periods) and 9 expressions (a bit mad). It looks something like this:

My problem is I want to add another expression, that is relative only to one of the dimensions and not to the Type dimension - the red Expression X. Tried and didn't work:

- Artificial Type 4 for the red Expression X. In this case I couldn't hide the other 9 expressions I don't want for Type 4

- Expression with if (dimensionality()=0, calculate me this). In this case I get my calculated Expression X for all types and when dimensionality=2.

Currently I am trying to create a little 1-row table, that I can stick up to the big table, but it doesn't seem like the best solution. I am doing this for a printed report, so no users are going to click anywhere.

Do you have any ideas for a workaround?

Thanks in advance!

Gizela