I've built sheets for each product line that contain a pivot table. Each measure contains something alone the lines of :
Count({<Species={Dog}>}Policy_No)
This has meant I have identical sheets for each "Species" with the same measures, exactly what I was after. However, I need to blank out the latest date in the pivot table.
I have an IF statement to identify this line, something like:
If ( LatestMonth = 'Y' , 0 , Count({<Species={Dog}>}Policy_No) )
This then brings back all the other "Species" lines that were previously hidden.
Firstly, how do I stop this?
Secondly, can I return a blank / null value instead of 0 if the condition is true?
