Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I have a question regarding filtering a straight table.
I have a list of users that can access applications (this is an exemple, the database is larger)
User | App
-------------------
User 1 | App1
User 4 | App1
User 2 | App1
User 2 | App2
User 3 | App2
User 4 | App3
User 3 | App3
User 2 | App3
I want to have 3 tables that look like this :
Table - App1
-------------------
User1
User 4
User 2
Table - App2
-------------------
User2
User3
Table - App3
-------------------
User 4
User 3
User 2
the count function work : count({<App={'App1'}>}[User])
but the way to show the only list doesn't, I've tried :
Aggr(({<{App={'App1'}>} [User]), [User])
if (App={'App1'},[User],'')
only({<{App={'App1'}>}[User])
Can someone please help me on this problem ?
Thanks in advance
Hi @Eugene81
I think you may have just used a slightly wrong syntax.
Try this:
if(App='App1', User)
Hope this helps!
Hi @Eugene81
I think you may have just used a slightly wrong syntax.
Try this:
if(App='App1', User)
Hope this helps!
Thank you so much @lennart_mo it perfectly worked
Subject solved