When I do a cross-tab I get the average values of my data. I also want to add that values to get a total row (add the average values to get a total, a sum), but the cross table only gives me the average of those averages. Is there any chance to get that total (adding but no averaging)?
I need it because I have data from several categories in several parcels. I need to report the average of these data by category, but then I need the sum of the average of all categories.
In the cross-tab, I have only one choice: sum or average, but I cannot choose one for the data in the cross-tab, and the other for the totals.
Is there any way to do that?
IP Logged
