Sum of 3 months of Measure to show as quarter value

[KHK]

Hi , I have below requirement

If one customer have revenue for three months like Jan,Feb.Mar(Q1).

Jan=100

Feb=20

Mar=30

Sum of Jan +Feb+Mar=150

This 150 value show in separate column to show 3 times in the report as below.

I want to calculate the Ratio by dividing sum of  revenue of quarter/Revenue.

Please let me know how to achieve.

[anurag]

You can use level based measure function to calculate sales total for quarter (Sum of Jan +Feb+Mar).

In your case formula can be:

SUM( <Revenue>,  groupBy(<customer>, <quarter>) )

To calculate ratio use this formula:

SUM( <Revenue> ) 

/

SUM( <Revenue>,  groupBy(<customer>, <quarter>) )

You can find more information about level based measure function here:

https://docs.incorta.com/latest/concepts-level-based-measure