first reload time

[himabinduch]

Hi All,

in my application i want to get the quarter details as below

if i am running the app for first time then i should get 2 previous quarters data if i am running that app next time it should show 3 previous Quarters data  it should repeat up to 8 quarters 

let’s say we are publishing this app in 2018 Q1 (i.e. Jan 2018) then the report will display data for 2017 Q3, 2017 Q4.

From there on, If reporting in 2018 Q2, we display data for  - 2017 Q3, 2017 Q4, 2018 Q1.

  To elaborate, if we are reporting on data in 2019 Q4, then we display data for quarters –2017 Q4, 2018 Q1, 2018 Q2, 2018 Q3, 2018 Q4, 2019 Q1, 2019 Q2, 2019 Q3 (rolling 8 quarters)

please help

Thanks,

hima.

[Anil_Babu_Samineni]

Perhaps this?

=Sum({<DateField = {"$(='>=' & Date(MonthStart(AddYears(Max(DateField), -2))) & '<=' & Date(MonthEnd(Max(DateField))))"}>} Measure)

[himabinduch]

Hi Anil,

it is not working for me

[Anil_Babu_Samineni]

Okay

[himabinduch]

Please let me know if you have any idea.

[Anil_Babu_Samineni]

Please provide sample and expected result on filter?

[himabinduch]

please go through my previous link so that you will have some idea.

Aggr Function