Create Report on the basis of Rolling Quarters

[gaurav2017]

Hi,

Scenario:

Given:

Sales data is on the basis of some date.

Problem: Presentation

Product	Current Quarter Sales	Last Quarter Sales	2nd Last Quarter Sales	3rd Last Quarter Sales
A
B

Logic:

When user select current month, the data should appear of that quarter in "Current Quarter Sales" with last 3 quarter sales.

Please help!

Any help will be appreciated.

Regards,

[Gysbert_Wassenaar]

It's easiest if you create a serial quarter number field in the script. See attached qvw.

[gaurav2017]

Dear Gysbert,

Please find a sample application. I am stuck in somewhere. I want to follow a simple approach with the use of variables at the frontend.

But thanks for showing me a different approach. Appreciate your skills.

Thanks & Regards,