Is it possible to build a view using column totals to show the following information? If not, what can be considered to be a good alternative?
Col. 1 (Cat.) Col. 2 Column 2(Total)
Sales Region Turnover Gross Profit %
Region1 6
10000 0
30000 8
Region2 15
20000 20
20000 10
----
10,5
Hope this is calculated correctly and makes the problem clear. No comments on the profits, please ![]()
Cheers, Dirk