Show two ref view of 1 referenced table

AppSheet AppSheet Q&A
1

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

3X_d_e_de6d9f892b620e86200f698270a6a64b83b259df.png
3X_d_e_de6d9f892b620e86200f698270a6a64b83b259df.png494Ă—653 57.7 KB

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.

3X_c_0_c0fc48291fbfc84b577498aaf20f12ca418cc320.png
3X_c_0_c0fc48291fbfc84b577498aaf20f12ca418cc320.png484Ă—786 48.4 KB

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

2

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”)

3 Likes
3

Wonderful, thanks @Suvrutt_Gurjar and have a nice weekend !

2 Likes