topic Sum of 3 months of Measure to show as quarter value in Dashboards & Analytics Discussions

Sum of 3 months of Measure to show as quarter value

KHK — Thu, 11 Sep 2025 06:58:00 GMT

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 — Mon, 15 Sep 2025 20:32:02 GMT

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: