Hi There i have a Report That Display's data in following format
Areas
1 What ever 3 0 2 1
2 ABC 0 0 1 0
-
Total 3 0 3 1
The Areas are Matric Columns and are dynamically generated .
i dont want sub total of each row , but i want Grand total at the end of the all columns generated by matrix
I have no clue how do to it
Kind Regards
Just Right-click the column header and choose subtotal.
|||No this is what i dont wantthis will add total below each row which i dont want i want the grand totals after the last row|||
OK, we seem to be talking cross purposes and your explanation is not clear enough.
If you want an additional column at the end the has the total value for all areas then right-click the column group and choose subtotal.
If you want an additional row at the very bottom that has the total for all the code/description row category, then right-click on the code group i.e. outermost group, and choose subtotal.
|||let me explain again here is the report's result few row
Total Row 0 African Colum total 0 15000 ( asian) rest of totals
the regions name that you see are actually column of matrix report and i want total in last row for each column
i have added total as column but i also want grand total row at the end
means horizontal total of each row
and vertical total of each column
i hope i got it right this time
Fine. Then doing what I said in my previous reply should work for you. Have you tried it?
Just to be totally explicit, right-click the textbox in your matrix that has the "code" and not the one that has the "description" and select the subtotal option.
|||worked thanks a lot
No comments:
Post a Comment