query in BEx
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
[ Amt-jan 2011 Amt u2013feb 2011 Total vendor]
[ Total jan 2011 Total feb 2011 ]