Possible? Column totals for weighted percentages

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 :slight_smile:

Cheers, Dirk