on 06-10-2011 8:39 PM
Hello,
I have a report which shows the spend amount for the vendors for the last 12 months. I am trying to add a column which shows summation of the amounts by vendor.
Now it shows only the total for each month.
How can I also show the totals for the vendors ( amount for each vendor) on the same report.
Can you please tell me how do i calculate the third column..i.e total amount for each vendor
Thanks,
-
[ Amt-jan 2011 Amt u2013feb 2011 Total vendor]
-
Vendor 1
Vendor 2
-
[ Total jan 2011 Total feb 2011 ]
Set the property for calendar month to display results always.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think you can make use of exception aggregation that shold take care of your aggregation part.
Just Make a new formula and add your amount field and hit the exception aggregation tab and choose aggregation as total and reference characterstic as calmonth.
In second case you can do the same thing and this time choose reference characterstic as vendor,so it will give total vendor wise.
Hope it helps.
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.