Calculated Dimension using ONLY function?

[poluvidyasagar]

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

[PrashantSangle]

Try this

if(wildmatch(Location,'AB','AC','AD'),Location)

Regards,

[poluvidyasagar]

It does not work

[poluvidyasagar]

stalwar1‌

Hi Sunny,

Can you help me on this one?

[jonathandienst]

Try this:

Aggr(Only ({<{Location-={'AB','AC','AD'}>} Location), Location)

[neelamsaroha157]

Check this out...added expression with if condition as well as set analysis.

[poluvidyasagar]

It does not work

[poluvidyasagar]

I can't see anything attached

[poluvidyasagar]

This worked for me:

=if(Not Match(Location, 'AB','AC','AD'),Location)

Check suppress when value is null

[poluvidyasagar]

I would still like to see if this can be achieved using Only function with set analysis

swuehl‌