how to aggregate on Year node/level

[Sowmiya_C]

Hello,

We would like to create an input schedule with a calculation on a ratio and calculate it at Year level.

Unfortunately all ratio are calculated for each month then summed up.

We would like to sum up for all 12 months then calculate the ratio for the year.

Any idea?

Thanks in advance.

Laurent

[Sowmiya_C]

Hi,

Can you explain your scenario with an example ,so that we can understand easily.

Thanks,

[Jay_Gandhi]

Hi there,

Depending on your specific use case and dimensions used you could create a calculated measure to do so.

For example you could turn on exception aggregation for your 'base' measure to calculate the appropriate values by month and then an aggregated measure which sums these base measures to create the correct value at the node/year level.

Jay