Column Total as Average and Row Total as Sum

[balawatt]

Hi, I have a Measure field which is aggregated with ‘Sum’. So when Row totals are pulled, it will still consider SUM as aggregation, However I want the column total to be ‘AVG’. Is this possible?

[apjvinod]

Hi @balawatt

Yes you can define different aggregation rule for the totals . On the field well → choose measure–>click on elipses ( three dots) → Totals → Choose Avg

Thanks
VInod

[balawatt]

Thanks @apjvinod , I want Average only for Column total, not row total. What you are recommending would lead to Average for both Column and Row Totals.