Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to use If loop in dimensions.
[Location ] & ': ' & [ Name], i have this as dimension , also how can i include specific location like {<[Location] = {'US'}>} in this set analysis .
Not sure but try this
= {< [Location] = {'US'} >} [Location] & ': ' & [Name]
Or
you can create calucauted dimension like below
=if([Location]='US', 'Location: ' & [Name], [Name])