Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I manage to filter dimensions when I only need one definition, for example:
=if(Customers.Area='North', [Customers.Tier],Null())
I've tried to figure out how to add another definition but haven't succeeded. For example this doesn't work:
=if(Customers.Area='North' and Customers.Tier = 'New', [Customers.Tier],Null())
Would somebody please tell me how to do it properly?
Perhaps this?
=if(Customers.Area='North', If(Customers.Tier = 'New', [Customers.Tier],Null()))
Perhaps this?
=if(Customers.Area='North', If(Customers.Tier = 'New', [Customers.Tier],Null()))
It indeed is - thank you for the quick reply!