Sum of previous quarter

[reporting_neu]

Hi there,
I'm struggling to find a total for the last quarter.

I would like to always see a total from the last quarter.

Sum (distinct VST_Call.Call)

I have a master calendar called MASTER_CAL.Date and also a calendar for the quarters called MASTER_CAL.Quartes (Q1, Q2, Q3, Q4). In addition, the VST_CALL has a date field called "createdate". This is linked to the master calendar.

How do I get the total from the last quarter?

I am desperate ...

[Lauri]

You can try set analysis:

Sum ({<MASTER_CAL.Quartes={"=$(=max(MASTER_CAL.Quartes))"}>} distinct VST_Call.Call)

[AshutoshBhumkar · Accepted solution]

Hello,

To get last quarter data you can use below set analysis code.

Sum(distinct {<createdate= {">=$(=Quarterstart(Max(createdate),-1))<=$(=QuarterEnd(Max(createdate),-1))"}>}

VST_Call.Call)

Hope this helps.

Thanks,

Ashutosh

[reporting_neu]

Thank you all 🙂