Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a list of customers. However i want to create a chart/straight table showing only customers containing the word say , "Cars".
How do i do this.
Thanks
kind regards
Nayan
Hi,
You can use the set analysis to restrict the records.
Your expression should look like below.
Sum({<Customer_Name = {"*CARS*"}>}Sales)
Regards,
Kaushik Solanki
Hi Kaushik
Thanks. Your formula above relates to a value ..."Sales". Is there a way, without the value. Can you do an if formula.
kind regards
Nayan
Hi,
Set Analysis works same like if statement at brief, and its very powerful then if statement.
If statement in expression is not a best practice.
Regards,
Kaushik Solanki
Hi Nayan,
Checkout these videos on YouTube
IF WILDMATCH
pick wildmatch
Create "Calculated Dimension" and put:
IF(WildMatch(Customer, '*CARS*') = 1, Customer, NULL())
Now Suppress NULLS on dimension.