Skip to main content
Member
Apr 26, 2022 8:37 PM UTC

Member Filter: Summation of an Expansion

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

6 replies

Member
Apr 26, 2022 8:38 PM UTC

image.png

Member
Apr 27, 2022 1:55 PM UTC

I'm wondering if you can do the alt hierarchy for this report sake. But you can definitely use the XFBR.

Member
Apr 27, 2022 2:58 PM UTC

We are trying to avoid the maintenance associated with an alternate hierarchy, would you happen to have sample XFBR to perform this task?

Member
May 4, 2022 5:20 PM UTC

Is this only for Quick Views or Cube Views/Reports as well? 

Member
May 4, 2022 5:23 PM UTC

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.

Member
May 4, 2022 5:46 PM UTC

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.