Forum Discussion

CAIGuySeanF's avatar
CAIGuySeanF
Contributor
3 years ago

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 t...
Cube View
SxD's avatar
SxD
New Contributor III
3 years ago

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

  • CAIGuySeanF's avatar
    CAIGuySeanF
    Contributor
    3 years ago

    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.

    • SxD's avatar
      SxD
      New Contributor III
      3 years ago

      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.