I want to filter 2 itens of a dimension (SG&A and R&D), how can I do that?
The formulua I created is this below, but I don’t know how to add another item with SG&A.
[filter: 'P&L type'= 'P&L type'."SG&A"]
Answer
Filter 2 items
- Wallflower
Best answer by francois
Hi Carolina!
You can add any conditions with AND or OR operators, like so: ‘Source Metric’[FILTER: 'P&L type'= 'P&L type'."SG&A" OR 'P&L type'= 'P&L type'."R&D"]
Let me know if this works for you!
François
+13- Employee
- Answer
Hi Carolina!
You can add any conditions with AND or OR operators, like so: ‘Source Metric’[FILTER: 'P&L type'= 'P&L type'."SG&A" OR 'P&L type'= 'P&L type'."R&D"]
Let me know if this works for you!
François
François (Pigment)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.