How to show customized values instead of zeros or grey out option for un associated selections..??

[vishalgoud]

We have a fact table which contains the data upto august 2017 and for the same fact table 3 new columns are added from sep,

so now we are concatenating both qvds and we are showing 0 for the new column values when the users selected dates before august.

we want to show some other values like 'NA' or 'No Data' etc as the value in the new columns when the users selected dates before august.

Any alternate for this. PFA

Thanks in advance.

Best Regards,

Vishal

[ieuyar]

Create a mapping table with a key and that field only with values which you desire to show and then use applymap function like this:

Applymap('MapTable',YourKeyToMapTable,'N/A')