Is it possible to add an expression for certain columns of a pivot table?
I have a pivot table where I pivoted one dimension. The secondary dimensionality of the aggregate is 0, the secondary dimensionality of the subtypes is 2. I now want to add two expressions that are only calculated and shown for the aggregate. I am, however, at a complete loss about how to get there.
If I add an if-condition like if(SecondaryDimensonality()=0, sum(Flag)) the expression is also added to the subtypes, only it's empty there. Is there a possibility to achieve what I want to? I'm using QV10 SR3.
Hei. Thanks for pointing me there. I had already read this one, however. I also know, that I can have different expressions in different columns according to their dimensionality. My problem is, that I want to add an expression only to a certain column (it splits the column into two) and keep the other columns as they are. (I tried to add a picture that might be able to explain better what I try to achieve, however the upload here is not functioning at the moment.)
