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
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.