Hi, I am looking for a way of using the filter function with two conditions.
Example: Looking for a sum of specific accounts and cost centers. lets say for accounts: 400,401 and 406 and from cost centers 21;1000;1150;1321;1400;2321;2400.
I am already using the filter to look for the sum of the accounts, but found out that I need it on specific cost centers as well
Any ideas how to solve this? :)
Best answer by Franck CView original
have you tried using the filter modifier and the “in” operator ? Something like this :
Hey Franck, thanks! how do I combine the filter for cost center specifications and specific accounts? :)
You can use AND and OR :