Display specific values in date filter

[onkar1988]

Hi All,

I have a requirement to populate specific quarters in the date filter.  I have data for Q3 2019, Q2 2019, Q1 2019 and Q4 2018 in data. I am pulling data from below table where in current quarter is where flag ='N'.

Period_ID	Position_Year	Position_Quarter	Period_Closed_flag	sales
1	2018	Q4	Y	100
2	2019	Q1	Y	200
3	2019	Q2	Y	300
4	2019	Q3	N	400

I want to display (current-1) quarter and last quarter of prior year always in 'historic period' filter.

If my current quarter is Q3 2019,  I want to display Q2 2019 and Q4 2018 in 'historic period' filter.

If my current quarter is Q4 2019, I want to display Q3 2019 and Q4 2018 in 'historic period' filter.

Let me know if I am clear with my requirements. Thanks 🙂

Regards,

Onkar Kulkarni

[sunny_talwar]

Display this where? I am not sure I understand where exactly is this displayed and how?

[onkar1988]

Hi Sunny,
Thanks for the reply. I want to display it in Filter pane- 'Historic Period'.