04-26-2022 04:37 PM - last edited on 05-24-2023 12:12 PM by JackLacava
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
04-26-2022 04:38 PM
04-27-2022 09:55 AM
I'm wondering if you can do the alt hierarchy for this report sake. But you can definitely use the XFBR.
04-27-2022 10:58 AM
We are trying to avoid the maintenance associated with an alternate hierarchy, would you happen to have sample XFBR to perform this task?
05-04-2022 01:20 PM
Is this only for Quick Views or Cube Views/Reports as well?
05-04-2022 01:23 PM
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.
05-04-2022 01:46 PM
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.