Set Expression in if statement

[Seb_Sanders]

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?

Thanks

[marcus_sommer]

Maybe in this way: Count({<Species={Dog}, LatestMonth = {'Y'}>} Policy_No)

- Marcus