display views last 30 days, last 60 days, last 90 days

[ram_k19]

Hi Guys,

My requirement is related to custom BO based / custom DS / custom Report or view.

i can display based on datewise view, but my requirement is to create a view  - that should display last 30 days issued materials, last 60 days issued materials, last 90 days issued materials.

plz share any idea to fix this issue.

thanks / ramesh.

[Former Member · Accepted solution]

Create a restricted key figure in the second step of report creation wizard.

You must be having a characteristic field "Date" which gives you the Material Issue date. So use that date field to restrict the new Key Figure.

So once you select the date in above screen, in the next step, you can give a fixed value like "Current Month" (for 30 days), "Last 3 months" (for 90 days) for that date field. So the data will be restricted.

So in total you need to create 3 restricted key figures.

[ram_k19 · Accepted solution]

Hi Hari,

Thanks, i implemented the things according to your steps provided last post, now i can display view based on last 30, 60, and 90 days.

thanks once again.

br / ramesh.