Hello,
Is there a way to aggregate the result of an expansion within a member filter? For example, I have multiple entities that are Australian. I would like to aggregate the balances of all of those entities into a single row. I'm using the attached syntax which produces the entire list, but I would like all the results to be aggregated into one line item without all the underlying detail. Does anyone know of a solution?
Thanks,
Sean
I'm wondering if you can do the alt hierarchy for this report sake. But you can definitely use the XFBR.
We are trying to avoid the maintenance associated with an alternate hierarchy, would you happen to have sample XFBR to perform this task?
Is this only for Quick Views or Cube Views/Reports as well?
Ideally QVs and CVs. I tried to replicate the logic in a CV (CVR reference) and wasn't successful as it took only the top member expansion from the list.
I don't know the XFBR Koemets mentioned, but I was thinking as an alternate route, maybe a UD8 (reporting) or Account with a DynamicCalc formula could meet your needs. Writing it so it calculates based on the Entity's currency or a text field.
