Hello everyone,
I have two Master alternate states: Wave1 and Wave2 to compare various stats by different Waves (Wave = dimension). I have a table and 'Wave2' is selected under Alternate State.
To get the name of people in Wave2, I am using this formula:
=Aggr( Only({Wave2} Name), Name)
The only problem is that I have the same person (Allen) in A_Wave and C_Wave. Whenever A_Wave or C_Wave is selected, Allen will show up in the table twice while he should only show up once.
I would like to know why it's happening and how I could fix it.
Thank you for your help.
