Weighted by another measure not working with Aggregate and calculate option.
We have defined a custom measure to calculate MAPE which is with aggregate and calculate aggregation parameter. And it is defined with Weighted average of Sales history.
Expectation is to weight MAPE by sales history when viewing it at aggregated level by enabling Summaries at pivot table. So at Summary level, it should do a weighted average calculation of sales history and then show the MAPE.
Observed that at Summary level, it still follows aggregate and calculate and dont honor weighted average by sales history.
Is it expected behavior, if yes do we have any workaround to achieve this.
Thanks
Tagged:
0