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