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?
Hema Tulasi Boppana.