Comparing 2 measures which are at different level of aggregation.

rahul8273 — Mon, 06 Feb 2023 11:15:37 GMT

Hi Community,

In one my use case I want to compare the 2 measures which are in different level of aggregation.

For Example

Measure 1 : Avg(Aggr(Sum(Profit)/Sum(Sales), YearMonth, Product))

Measure 2 : Avg(Aggr(Sum(Profit)/Sum(Sales), YearMonth, Product, Country))

Now in my final output viz I will have Product on Rows and Country on Col (in pivot table) and in the values I want to show the difference between the measure1 and measure 2.

It may be straightforward but I am stuck on this.

Re: Comparing 2 measures which are at different level of aggregation.

jbhappysocks — Mon, 06 Feb 2023 13:30:23 GMT

Change measure 1 to Avg(total <Product> Aggr(Sum(Profit)/Sum(Sales), YearMonth, Product))

(If you add YearMonth to the pivot it's total <Product, YearMonth>)

topic Re: Comparing 2 measures which are at different level of aggregation. in App Development

Comparing 2 measures which are at different level of aggregation.

Re: Comparing 2 measures which are at different level of aggregation.