BEx Query Scenario.

Dear All,

Good day!!

I have a scenario. I have created a query.

In Columns, I have 2 key figures--> NO OF PROJECTS and PROJECT VALUE.

In Rows, I have Project number and Cal month.

"NO OF PROJECTS" is a Calculated Key figure to get the project count..

Now the user wants to see the NO OF PROJECTS and PROJECT VALUE from the current date/System date to previous year same date.

Can you please guide me how to achieve this?

Thank you,

warm regards,

Hema Tulasi Boppana.