Different results in lines and columns
I have this query where I wanted to have columns totals calculated as SUM and row totals calculated as AVG.
The query results I wanted are has shown below, but I am only able either to have SUM or AVG in rows and columns.
Month 1 Month 2 Total
Calculated KF Calculated KF Calculated KF Total
KeyFigure 1 3 2
KeyFigure 1 1 1
Total 2 4 3