You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Weighted by another measure not working with Aggregate and calculate option.

Received Response
21
Views
1
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!