Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to achieve the following:
Sample Data:
Location | Sublocation | Part |
A | A1 | 12345 |
B | B1 | 23456 |
B | B2 | 12456 |
C | C1 | 14678 |
C | C2 | 18992 |
D | D1 | 18320 |
D | D2 | 10302 |
AB | AB1 | 10320 |
AC | AB2 | 13920 |
AD | AB3 | 10401 |
My Dimensions are:
1. Location
2. Sublocation
However, I do not want to show all Locations as my dimension. I would like to use ONLY function with set analysis ?
I have tried the following but it does not seem to work:
Only ({<{Location-={'AB','AC','AD'}>}Location}
Basically i do not want to show locations with AB, AC, AD. Since this is a sample data set, i am only showing few location. However, i have quite a few locations that i want to show and exclude some. That is why i am going with not contain in set analysis.
Can someone help me on this?
I have attached the sample file.
Thanks,
Vidya
Try this
if(wildmatch(Location,'AB','AC','AD'),Location)
Regards,
It does not work
Try this:
Aggr(Only ({<{Location-={'AB','AC','AD'}>} Location), Location)
Check this out...added expression with if condition as well as set analysis.
It does not work
I can't see anything attached
This worked for me:
=if(Not Match(Location, 'AB','AC','AD'),Location)
Check suppress when value is null
I would still like to see if this can be achieved using Only function with set analysis