Hello sam,

The attached workbook might meet your request 1.

I also made some changes to your existing calculations, including add IFNULL to your event counts, and [SHAPE: Change].

I still left the NULL for [YEAR: Change] for it's divided by zero.

And a question for request 2.

Do you want to compare month/quarter with last month/quarter or with the same month/quarter of the previous year?

Regards

Lei

Hello Sam,

Happy to hear that

I suppose the four variations of comparisons are all possible, with more calculated fields.

Sorry that I may not have enough time for this today.

Please wait a while.

Regards

Lei

Hello SAM,

Sorry for having kept you waiting.

I'm back with the attached sample workbook.

Now we have three parameters.

Parameter 1. Select Comparison by

Choices are,

• Year
• Quarter
• Month
• Quarter vs Last Year
• Month vs Last Year

Parameter 2. Select Year

When "Year" is selected in Parameter 1, this parameter works.

Parameter 3. Select Year-Quarter

When "Month" or "Month vs Last Year" are selected in Parameter 1, this parameter works.

I've prepared everything ready for "Year", "Quarter" and "Quarter vs Last Year" in Parameter 1.

Please check the results.

Then here comes your homework.

Please give it a try at setting up "Month" and "Month vs Last Year" and enjoy the process

Please feel free to ask if there's any question.

Regards

Lei