Crosstab Display String Formula

Hi All,

Is there anyway to change the display string of a single cell (in this case homework)in a crosstab based on a condition? Eg:

I have this crosstab:

Confidence,Homework,Age

1 2 14

So i'm trying something like this:

If subject="RE" and ColumnHeader ="Homework" then "NA"

And the result i'm after is:

Confidence,Homework,Age

1 NA 14

Any ideas anyone?

Many Thanks,

Dave.

Edited by: Dave Kenney on Jun 25, 2009 9:40 PM