In a Cube View, how do you get calculated columns to accommodate different calculations based on the account?

Answer

• Create a UD8 member with a dynamic calculation to read the account in the row.
• Then, use a select case to vary the formula by line item.
• If the account is not included in a case, then return nothing to populate a blank cell.

Source: Office Hours 2020-08-27 Partner Enablement