Sorting field using 2 values in the same column

[matbelli]

Hi, i have a table like this
Id idcausale
1 28
2 27
1 27
2 27

I have to filter the id, such that it shows only id that has both 27 and 28 on idcausale value. How can i do it? Thanks

[tresesco · Accepted solution]

To get those Ids in text object, try like:

for only those two

=Concat(DISTINCT {<Id={"=Concat(Distinct idcausale)='2728'"}>} Id, ',')

 For at least those two

=Concat(DISTINCT {<Id={"=Wildmatch(Concat(Distinct idcausale),'*2728*')"}>} Id, ',')

[sunny_talwar]

You can also try

{<Id = p({<idcausale = {27}>})*p({<idcausale = {28}>})>}