Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

query in BEx

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 ]

Former Member
replied

Set the property for calendar month to display results always.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question