Creating Calculations in Blended Charts and Tables
Create a calculation using measures and dimensions from multiple models.
You can create simple calculations using measures or account members from multiple models in your blended chart or table. When creating the formula in the formula editor, the auto-complete options will include measures from all your linked models.
Note
You cannot use IF or ResultLookup functions in
formulas that use multiple models.Calculations in Blended Charts
In the Builder, members and dimensions from the primary model are identified with a dot.
Calculations in Blended Tables
When you switch between linked models for your blended table, the list of calculations will contain all the available calculations for the current model.