I have created a table with names of companies in Column A and Boolean values under different columns for Rising Sales, Rising Profit and Rising Margins (in Column B, C and D respectively). Now, some companies will be satisfying more than one Boolean also.
How do I create a dropdown control with options for Rising Sales, Rising Profit and Rising Margin, such that I can choose more than one together?
I tried to do it by creating a custom filter using CASE function, but it gives me result for only Rising Sales. If I choose Rising Profit, it removes companies which have Rising Profit also. Similarly, choosing Rising Margin removes companies with Rising Sales or Rising Profit.
CASE
WHEN Rising Sales then "Rising Sales"
WHEN Rising Profit then "Rising Profit"
WHEN Rising Margin then "Rising Margin"
else "None"
END
You may see the report here: https://lookerstudio.google.com/reporting/2934ea5c-1ea1-41ca-bc98-6588f7186a31
| User | Count |
|---|---|
| 5 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
LinkedIn
Twitter
