Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have dimension called Business Area as below
Business Area |
RoA |
MIWI |
Function |
So what I want to achieve is
Business Area |
RoA |
MIWI |
Function |
All |
Where the record ALL ='ROA','MIWI,'Function'.
I have tried this statement below but its's not working.
if(Match([Business Area],'Function','RoA','MIWI'),'ALL',[Business Area]) as [Business Area2]
Regards
Thank you for the response. How do I then create the record ALL? Should I write an if statement