An action link in a pivot on a measure based on a condition on the measure itself perfectly works (just tried it 10 seconds ago).
So all I can suggest is to double check your condition....
Maybe try the condition as conditional formatting first to find the good rule, but it definitely works.
I am not sure. I applied custom data format on the column. Will it cause any problem? I tried with other columns not measures, it is working fine.is there any other reason to fail the condition?
Maybe "what you see is not what you get" ?
You see a value in that column because of some formatting but the real value is something else (the condition will match the real value, not the "display format" value).
I am not able to identify the issue.I am getting null values in the report at pivot table view aggregation level.I am replacing the values with 0.exactly what type of conditional navigation have to apply here?
1 person found this helpful
I am replacing the values with 0.
How/where do you replace the NULL with 0 ?
Do you use the 3rd parameter of the format of the column?
In that case you are not getting a NULL value, you are not getting any value, and you can't add an action link on something that doesn't exist (like conditional formatting will also not work).
(NULL is a value, empty is no value at all, it's different)
I applied the data format to no value as 0.How can I implement the conditional action links on the same?
Replacing no value with 0 is MUST requirement.
Ok, so your problem is a little more complex ...
To have an action link on the cells with 0 because of no value you will need to get a real value there, it's the only way if you don't want to change the requirement and change the way you navigate.
The easiest would be to adapt your ETL to produce real "0" in the DB, plan be you can try with a cartesian product generating all these values as 0 "on the fly" (but your performance will really not be good at all when doing that in general).