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.
Thx
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.
Cheers,
Alex
Will have a look and get back to.
tried it a while ago but did not come right the first time round
Thx @LiliSadikin
I need to calculate total value of row and not column if that makes sense?
