[SOLVD]Re: subtotal of a cross tab with average, total and count 4 seperate clmn

[UseCog]

Hi All,

I have a cross tab and I want to show the subtotal of the cross tab. But I want to show total for the first column, average for the second column and count for the 3rd column

any helps on this please

[UseCog]

Thanks for your thoughts. I have got the solution

Rather than using a specific type of aggregation (such as Total or Average), click on the Summary button and select Aggregate. This will use the Rollup Aggregate Function defined for each data item in the query. If the rollup aggregate function is Automatic, the aggregate function defined for the data item in the model will be used instead