Period over Period Measurements

Hi Anonymous,

Do you mean YTD,QTD and MTD measurements? There are formulas for this TOTALMTD, TOTALQTD and TOTALYTD and depending on the date you can define if it's currrent year or previous etc.

Mfelix

HI Anonymous,

 

It is possible to calculate through period records if your table contains the date or other types which can be the index.

For other scenario, it is impossible.

 

Regards,
Xiaoxin Sheng