Skip to Content
0
Former Member
May 05, 2008 at 10:09 AM

Last 3 years comparison for the KPIs

39 Views

hi BW gurus,

i am having fields customer, quantity, sales value in my report.My requirement is when i enter the todays date as variable my report should display quantity and sales value for the last 3 years for all the customers.

customer year 2006 year 2007 year 2008

1000000 Q SV Q SV Q SV

Q-Quantity kpi

SV-Sales Value kpi

Can u please explain of how to achieve this task in a step by step manner.

Regards,

Syed

Edited by: Shahid Syed on May 5, 2008 6:09 AM

Edited by: Shahid Syed on May 5, 2008 6:10 AM