calculate data for 10 rolling Quarters

KKR — Tue, 25 Nov 2025 09:26:06 GMT

Hi,

I want to Calculate data for 10 rolling Quarters.

I have created Session variable using Current date ,QTR format is 2025-Q4.

I have created Presentation variable using above created Session variable.

now i want create a formula to calculate data from current quarter to previous 9 quarters.

i tried below one ,it showing null value. tried Using presentation variable and session variable getting null value.

addQuartes(parseDtae($current_Quarter,'yyyy-QQQ'),-9).

Let me know how to write formula using session variable.

Re: calculate data for 10 rolling Quarters

mhornak — Fri, 12 Dec 2025 13:56:34 GMT

Hi,

you can use this formula in an individual filter — it includes the current quarter.

between(

Date.date,

quarterStartDate(

addMonths(

$currentDate,

-27

)

$currentDate

)