I scanned through the posts and found how to do it via If (var- inlist....) etc. And can get the logic to work. However, when using the groups, all I get is UNAVAILABLE for measures. My scenario:
GROUPA = a,b,c,d
GROUPB=e,f,g
GROUPC=h,i,k
I then want to filter a result table using GROUPA,GROUPB,GROUPC as input filter.
Filter gets created...appears to filter the table , but no measures.
If filter against a,b,c,d,e,f,....it works fine.
What am I missing here? The dimension of a,b,c,...is included in the table (that's how I know it is filtering)
thanks for any input here!
jim