Cyclic Groups and un-accumulated %

[#1]

I am trying to incorporate a cyclic group for my dimension in the chart below. However, when I cycle through the group, which is defined based on different time frames such as on an annual, monthly, and quarterly basis, each time frame cumulates my expressions.

Example Chart: Unfiltered

Example Chart: Filtered

How can I make it so when I drill down, quarterly values displayed are not cumulative?

[sunny_talwar · Accepted solution]

What expression are you using?

I would something like this:

Avg(Aggr(YourExpression, Monthly))

But to offer more help, need to know more details.

Best,

Sunny

[#3]

Opted for AVG() instead of SUM(). Thanks sunindia, again!

[sunny_talwar]

No problem

I am glad we were able to figure it out.

Best,

Sunny