Select specific months

How do I select the first 3 months of each FY?

For ex:

Revenue SELECT: Month.Quarter] gets me the revenue for each quarter. but now I want just Q1 in each FY. How do I do that?

Page 1 / 1

hi @Lester Chow

You have Revenue Metric and want to filter data of your Q1 Revenue from Revenue Metric.

Revenue Metric

For Q1 data from Revenue Metric

Apply following formula:

RevenueRMonth.Quarter.'Quarter of Year'='Quarter of Year'."Q1"]

Hope, I have answered your question.

Thanks

Sign up