I have 2 modules one is for performing calculations the other is to report on the calculation results. The line items in the calc module align with a list, not a line item subset, that the reporting module is dimensioned by. There is a single line item in the, Amount, in the reporting module. One other twist is that I need to sum the values based on a line item in the calculation module that aligns with another list in the reporting module.
Is there a way to do this such that the formula for Amount is not a nested if statement?
Calc Module Dimensions:
SKU-Cost Center(Concatenated)
Calc Module Line Items:
Department(Parent of CC)
Advertising
COGS
Reporting Module Dimensions:
Accounts(Contains Advertising and COGS)
Department
Brand(Parent Hierarchy to SKU|CostCenter
Line Items in Reporting Module:
Amount
Any help would be appreciated