I have the following situation.
Here is my data:
So in a pivot chart, i would like to get the following:
I tried to use the following script but it does not work. I understand the reason behind but i would like a better logic.
= pick( Match(left(Location,2),'2c'), '2c Setup')
Can someone improvise this logic to get me what i want as the result.
Rightnow, i only get the following as my result.
=Pick(WildMatch(Concat(DISTINCT '|' & Location), '*|2C*'), '2C Setup')
View solution in original post
Awesome.. It worked.