Getting the data from the selected date(Year or Quarte) backwards

[lindelanifakude]

Hi 

So I want to count the number of active cases but not only per selected quarter  but I want count from the selected quarter backwards. Example I selected last quarter of 2020 (Oct - Dec 2020) I don't want to count the active cases for Oct - Dec but I want to count all the active cases from the last quarter of 2020 back.

I have a quarter on the list box as you can see on the attached pic.

I hope my question make sense. Below is the sample of my expression:

count(if(BV_Ind=1 and GHHInd=1 and ActiveInd=1, CaseId))

[Marcos_Ferreira_dos_Santos]

Hello lindelanifakude,

Your need is perfectly feasilble applying Set Analysis, isn't it ?

Best regards

Marcos