Crosstab Sums

[hem852]

Hi,

I have a crosstab with a list of measures down the left and periods across the top. The final column of the crosstab is a sum giving the total for each measure for all periods.

For one measure (headcount) I would like the last column to show the maximum value rather than a sum. Is there a way to make the column calculation work differently dependent upon which measure it is calculating?

Logically its just something like

IF Measure='Headcount' THEN MAX(Measure) ELSE SUM(Measure)

Could someone please help me convert this to something that will work in my crosstab in reportnet?

TIA

Regards
John

[Gollapudi]

Hi,

You can achieve it by using discontinous crosstab, just add a Query Calculation at rightside of your cross tab and give the expression like this

maximum(Total([Headcount] for [Dimention1],[Dimention2],...upto required) for report)

This will works fine...

Thanks,
Gollapudi.