In a cross tab I need the display value to be "N/A" if no value exists for the intersection as it current displays zero.
I have tried formatting the cell using the "Display String" function on the common tab with a formula:
if isnull(measure) then "N/A"
but it doesnt work. Any ideas?