Forum Discussion
yanzhao_LBS
Helper II
Helper IIHow to get a table like this
I have 3 tables 1. 2. 3. and I want a table to display all the information detail like this: but it seems that it's ok to display the sum of them or one is sum the o...
It looks like the expected output only need the data from table 2 and 3.
You can create index and custom columns in PQ for both table, then merge two tables.
pls see the attachment below
ryan_mayu
Super User
Super Userthis solution doesnot conisider the number of rquest and consum qty.
It only depends on the rows of each product code.
yanzhao_LBSHelper II
Helper IIbut if i merge like this (conusmed is on the top)
the result will be like this