Hello I have a table named JANUARY, which has a column "Cost Center" and other columns for values to show.
I also have a USER table, having "Email" and their assigned "Cost Center".
Now I have created a slice where a USER only sees rows having the same Cost Center on JANUARY table - got that working.
But I would Like to ask for help on how to filter my slice to show more than one Cost Center values on JANUARY table, when the assigned Cost Center on USER table is 2 or more.
USER Table:
JANUARY Table:
Now I want the filter to show rows for test@test.com that has the cost centers 1231 and 1211. Any help would be greatly appreciated.
Solved! Go to Solution.
What is the type of the [Cost Center (old)]?
You should make it an ENUMLIST.
If it is of type TEXT then you could use SPLIT([Cost Center (Old)], ",") to make it into a list. But SPLIT is not 'reliable' because the delimiter has to be precise and TEXT editing is usually very unreliable in terms of entering the right string, so I would usually stay away from it.
User | Count |
---|---|
16 | |
12 | |
9 | |
4 | |
3 |