Is it possible to display Characters in Cross tab report instead of Numbers..

[rajua99]

Hello,

I have a requirement where i need to display 'Y' when there is a value 1 in the Cross tab or 'N' when there is no value. attached is screen shot from the report. Is there a way to format the measure object to Display as Y or N depending on the value in the measure..

Thanks,
Raju

[MFGF]

Hello,

I have a requirement where i need to display 'Y' when there is a value 1 in the Cross tab or 'N' when there is no value. attached is screen shot from the report. Is there a way to format the measure object to Display as Y or N depending on the value in the measure..

Thanks,
Raju

Hi,

The way I would do this is to select the crosstab fact cells, and define a conditional format for the cells containing a 1. Repeat for the others where the cells are empty (or use the Value if Null formatting option)

Cheers!

MF.

[rajua99]

Thank you MF. It worked.