Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.)
Hi,
Please can you upload sample QV file? I understand that you can't upload picture but can you give another try?
Thanks,
DV