i have created a virtual column with app formula as SELECT(Table1[ID], [ID] = [_THISROW].[ID]), with type as List and Element type as Ref and ref table is Table1 with item separator as " , ". this is to show the related data , but i am seeing this in the view (image 1) and when i click on it it will open into detail view , can anyone help me with this, as i want the result of the image 2
Image 1
Image 2
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |