cancel
Showing results for 
Search instead for 
Did you mean: 

query in BEx

Former Member
0 Kudos

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 ]

Accepted Solutions (1)

Accepted Solutions (1)

former_member183777
Active Contributor
0 Kudos

Set the property for calendar month to display results always.

Former Member
0 Kudos

Thank you Vineet

Answers (1)

Answers (1)

anshu_lilhori
Active Contributor
0 Kudos

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