Help on qtd, ytd, yoy qtd, yoy ytd

[#1]

Hi,

In the attached qvw, can you please help me get the following level of metrics.

All metrics needs to be calculated for the year and month selected and for every Region and Sub Region.

1. Actual Number, QTD, YTD for the selected month
2. YoY, QTD YoY, YTD YoY for the selected Month

Thanks for your time.

Regards,

Tina.

[arniewolff]

Tina,

Usually, when you need to perform YTD, QTD calculations, you need to create a true master calendar that holds that information in Flag fields. Then you can use the flags to know when to add.

Here's an example of a master calendar that is auto-generated from beginning, end, current date, and LY current date fields. Perhaps this can help?

Arnie

[JonnyPoole · Accepted solution]

Here is a sample approach using variables and your existing data model and date dimension.

I completed a full sample set for the PP expression

[#4]

Jonathan/Arnie,

Thanks for your time. The solution works perfect.

I have another question. We are trying to replicate the excel sheet table attached in the image. Can you think about a way to get the same format i.e. Have the Monthly, QTD and YTD as columns for each actual metric and its corresponding year over year as rows.

Is that doable. Can you please take a look when you have some time.

Thanks,

Tina.