Problem with CASE Statement

[KEKeogh]

Everything I see says I'm doing this right but I keep getting dashes (--) in the column.

I have the following CASE Statement.

CASE [DSR].[VIEW_APPLN_AVAIL].[APPLICATION_NAME]
WHEN 'ADR' THEN 'Khurana'
WHEN 'Aegon Checkfree' THEN 'Keller'
WHEN 'Avg Cost' THEN 'Khurana'
WHEN 'AWD' THEN 'Khurana'
ELSE 'Unassigned'
END

Aggregate Function = Automatic
Rollup Aggregate Function = Calculated
Column Format = Text

Any help is appreciated.

Kathie

[PaulM]

Aggregate functions will only work with numeric data types, so the rollup aggregate function should be set to automatic or none.

Is this a list or a crosstab?

[KEKeogh]

Sorry I forgot that, it's a crosstab.

Changing the Rollup didn't seem to work either.  Now instead of getting the dashes, each different THEN option came out as a column header.

[PaulM]

This is probably your problem. Are you trying to put this data item into the measures section?

Put it in either the columns or the rows and it should work fine.

[KEKeogh]

I'm putting it in between the Column headings but still not working.

[PaulM]

what happens when you put it in the columns? Is it still giving you the '--'? What happens if you put it into a list?

[KEKeogh]

Not quite sure how I did it but it finally worked.