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
Solved! Go to 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โ)
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โ)
Wonderful, thanks @Suvrutt_Gurjar and have a nice weekend !
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |