Aggregation for row

Hi All.
I’m trying to create a report where the total of each row and column is a calculated.
I know the columns can be done and have done so.
The Rows is where i have the problem.
Each row is a different site (Ranging from 10-20 sites) so needs to account for that change also.
Shouldn’t be that hard i hope.

Hi Ott,

I’m not sure how your data is presented here but it sounds like a cross-tab could help you.

Please see page 7-18 of the Advanced Reporting Handbook for details on Data Cubes and Cross-Tabs.



Will have a look and get back to.
tried it a while ago but did not come right the first time round