Solved

Filter 2 items

  • 18 January 2022
  • 2 replies
  • 366 views

Userlevel 3
Badge

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"]

icon

Best answer by francois 18 January 2022, 18:39

View original

2 replies

Userlevel 6
Badge +14

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

Userlevel 3
Badge

It worked, thanks.

Reply