Skip to main content
May 16, 2025

Dynamic Calc UD8 Dimension to Filter Account Dimension?

  • May 16, 2025
  • 0 replies
  • 0 views

Is it possible to create a dynamic calc UD8 dimension, that then filters down the members on the Account dimension at a base level? (and if so, how?)

For example, within the Account dimension, I have Member A, Member B, Member C and Member D.
Can I create UD8 dimensions of "Group 1" and "Group 2" where if Group 1 is selected, it filters down Account to only show Member A and Member B. And if I choose Group 2, it filters Account to only include Member C and Member D.

I know this can be accomplished with an alternate hierarchy on the Account dimension but just checking to see if this can be done alternatively. 

Thanks in advance!