Did you try using the column totals for the totals on the last column.
And why are the totals in the Total Column incorrect? the first row does not sum to 8
B4 answering your question, there might be something wrong in your data analysis. I see the total of the very first row is wrong, did u copy and paste or you just wrote the table on the fly on OTN?
But, for totals there are multiple ways: One will be to duplicate one of your rows then change the calculations and set it to whatever you want then add to the end as you wish.
Two, under row if you click whatever row you are trying to adjust there is an option to for "new calculated item".. this should also help you to manipulate the row as you wish.
Mark if it helps.
Yes, the first row total is wrong, I did it on the fly on OTN, the value I need to fix is the "80", the last value, the Total of the "Running Sum" row.
I cannot see what you mean by "under row if you click whatever row you are trying to adjust there is an option to for "new calculated item""
Can you pls explain this a bit more?
Also, what do you mean by Duplicate the row?
My report is
Select rows from table
Select Total from table
Select Cumulative Total from table
All this in a pivot view.
Ok, I hope I understood you correctly: my understanding is that '80' is the columns' total, so on your report click on the edit button.. then it will take you to the 'Editing from: Compound Layout screen'... At the bottom under layout there is many options: Go to the columns one, this has a 'Sum' icon and and column properties; if u click on the sum icon and choose 'Totals after' it should give you the sum total...
If that options didn't work you can click one of the columns in the "Columns' it should give you and option to duplicate. Duplicate it, change it to be your Rsum total as you wish..
Probably it is easy to show than to explain, but I have done it before.
I hope that helps
I know it is a lot to ask, but can you send me a screenshot of those properties you mention? I cannot find them.
I don't think Oracle forums allow us to share screen shots, what's email address?