Custom inline view

[_William]

I have this simple bill tracking app with three datasets:

Jobs 

bills

contacts (i.e. vendors)

I would like in the jobs detail view to have an inline  deck view list of unique vendors who have submitted a bill and a sum of their bills . I'm have a difficult time working out the logic to get this working. I was able to use select(bills[vendor id],[job id] = [_thisrow].[id]) to get a list of vendors, but it was a text list. 

Should I be thinking about a different way to implement this idea like a slice or something? Any help would be vary much appreciated. 

Thanks in advance

[Suvrutt_Gurjar]

Yes, you are on correct path. Please try creating a slice and base your deck view on that slice. In the related reverse reference column in Jobs table, please do remember to point to that slice name such as REF_ROWS("Slice Name", "Jobs Key Name")