Calculated dimension with multiple if statements

[#1]

I want to show a single calculated dimension which meets the following conditions :

IF BUSINESS_UNIT ='SALES'

IF REGION LIKE 'AMERICAS*',

IF SALESPERSON LIKE 'JOHN*',

Need some help constructing this statement with the correct syntax please.

[Anonymous · Accepted solution]

try

if (match(BUSINESS_UNIT,'SALES')>0 and match(REGION, 'AMERICAS')>0 and match(SALESPERSON, 'JOHN')>0, yourcalulateddimension)

[#3]

Awesome thanks. On the presentation side is there an easy way of hiding the dimension and expression labels ?

[Anonymous]

on either tab Dimension and Expression you may untick the Labels (or give own descriptions)

[#5]

Sure, mine is showing as greyed out in the dimensions tab though

[Anonymous]

it depends on the Chart type. a Pivot table you may Change the description but you cannot be without Label (you may define an empty text). in a barchart you may design your Chart without a label