My environment is webi xir2.My report has sections on it,sectioned by company name.My task is to calculate sub total and grand total for the company measures.I can get subtotal for a company measures.If i select multiple companies,under each section i need to get subtotal,but at the end of the report i need to get grand total i.e total of all companies irrespective of sections.I could get subtotal,but how to get Grand total?what is that i need to do for the report structure.
Hi all,
My formula for calculating sub totals on a report is
for [Asset Cost Amt] ----> =Sum([Asset Cost Amt])
for [Deprn Exp Amt] -----> =Sum([Deprn Exp Amt])
for [Ytd Deprn Exp Amt] …> =Sum([Ytd Deprn Exp Amt])
for [Deprn Reserve Amt] …> =Sum([Deprn Reserve Amt])
for [Asset Cost Amt]-[Deprn Reserve Amt] …>Sum([Asset Cost Amt]-[Deprn Reserve Amt])
so what will be the forumula for grand total,which i can find at the bottom of all sections.I tried in copying the same block,but it displaying the subtotal value at each section,i dont need extra row at each section,i need a row for grandtotal at the end of the report,calculating all section values.Please help me out.
Hi all,
I have a question.My report is a sectional report.I am trying to get grand total on to my report along with sub total.I can get sub total but i could not get grand total,as section is created.
Is it possible to get grandtotal while applying sections.
I know how to get grand total by applying breaks.
Is there anyway to get grand total by applying sections.
Jac’s original post was correct. From you you’ve said subsequently it sounds like you haven’t copied the cells to the right place. To get the grand total you need to copy the calculations outside of the section created by the master sectioning.
Try this : Copy the row that has the sub-totals in.
Scroll right down to the very bottom of the entire report.
Paste the row you copied there. This will be the grand total.
This might not be quite the place you want it, but it will work and then you can move that grand total upwards.
There is no formula for the Grand Total, Business Objects calculates the sum based on what section of the report you are in.
Copy the table after the section footer and fold the table data and show the TOTAL values in table footer. There is no way you can copy & paste individual row.
Thanks for your reply,
I folded the data table but when i refresh the report,i could see some blank rows before the grand total on the report.
How can i remove those blank rows.
Thanks for the pointer I wanted a grand total on my table and followed your idea and it worked perfectly. The only thing is you cannot copy a whole row but make a separate table with the sub total formulas pasted in the new table cells and give the relative position on the new table as per you want.
(BOB member since 2005-05-10)
(BOB member since 2006-06-01)