Show two ref view of 1 referenced table

[Phong_Lam1]

Hi all, I have a table Customer ref to table Potential orders as below

When I created a new chart view (ref type) from data of Potential orders, to show revenue of each product from potential order. Then the ref view above was replaced by a chart below.

How could I make it show both ref view of the potential order and the chart of It ? ( for ex: show Related potential order then, show related potential order chart below it)
Thanks

[Suvrutt_Gurjar · Accepted solution]

Please create a slice on the child table and the required reference view (chart or table as needed) based on that slice.

Please include a reverse reference column VC based on that child table slice in the parent table with an expression something like
REF_ROWS(“Slice Name”, “Key Column”)

[Phong_Lam1]

Wonderful, thanks @Suvrutt_Gurjar and have a nice weekend !