Skip to Content
0
Former Member
Jan 10, 2011 at 05:45 AM

BPC REPORTING

42 Views

Hi Experts,

I am working on BPC 7.5 NW Version.

And in the requirements i need to maintain 2 key figures in my Report and i need to have 3 Rows in my reports i.e Customer , line of business and Sales region .

So i have created an EVDRE with 3 Rows and 2 columns, now i want to have Subtotals and Grand Total in report for customer.

How can i achieve this and i want these totals for both key figures and when i am trying with After range and EVSUB it is showing the values of only one key figure and also not showing Subtotals based on each customer.

i want my report as :

Customer 1 LOB 1 Sales Reg 1 10000 1000

Customer 1 LOB2 Sales Reg 3 20000 2000

Customer Subtotal 30000 3000_

Customer 2 LOB1 Sales Reg 2 45000 4500

Customer 2 LOB2 Sales Reg 3 55000 5500

Customer 2 Sub total 100000 10000

GRAND TOTAL 1,30,000 13,000

Please help me in getting above solution from EVDRE Reports.

Chaithanya