Dear Netwerk,
I have a problem concerning calculated columns in my pivot table
I am using for my pivot table 1 row dimension and 3 different columns (which need to be drillable. This is all working fine but I also got 4 measures, these are calculated for each value on each level as it are measures.
I am now trying to show/hide a measure conditionally, is this possible?
My approach was to not calculate the columns I don't want and then deselect the option 'record zero values'. The output was that I still saw the column, but with no values.
Next approach was to create a valuelist and then by using an if function to determine wich measure should be used for each value and then deselect the option 'record zero values'. This was working fine on the last drillable level/column dimension, but when I drilled down an level/column dimension the values where gone. So I used the valuelist as an column dimension on the last level and it should be visible below the last drilldown level.
Any ideas on the two different approaches?
So I need to hide the measure when it is zero.
