Forum Discussion
Helper Isummarize report with 2 tables , not working
Community SupportHi REEDZHOU,
I am a bit confused about your excepted result, could you please tell we what is the reuslt you want?
Regards,
Frank
Helper IHi Frank
thank you in advacne
HAWB is listed with Orders, which is unique number. MS ODW page is all orders profit, but some orders generated profit in 2 financial periods or more, so they are not unique to listed by Country & UTN. I used order number in HAWB as unnique to linke to Country & UTN in MS ODW report. I want to generate the report from HAWB to list how many job count to get loss /gain or how much chargeable weight to get gain/loss? I broke down to order level. It is ok, all jobs will be listed chargeable & profit. If I want to summary to list them, the chargeable weight & job counts ( these 2 info are sitting HAWB page) are same as below
senario 1
Order | Job Count | Chargeable Weight | Profit
123A 1 523 300
234A 1 250 -100
Senario 2
Gain/loss | Job Count | Chargeable Weight | Profit
Gain 2 773 300
Loss 2 773 -100
The job count & chargeable weight are same in summary.
- REEDZHOUHi I want to explain more clear HAWB page report , 1 order 1 line, providing chargeable weight for each order MS ODW report 1 order with multiply line, providing shipment profit by different month progressing HAWB use order to connect MS ODW Connect report. I can use SUM to work out profit. Among these orders, some made profit, some loss. I created column to show " Gain or Loss". If I use order number in HAWB to generate how many job/chargeable weight gain, how many jobs loss/chargeable weight report. the total job /chargeable will be same sitting in the gain & loss line as below CW Job Counts Profit Gain 500 15 657 Loss 500 15 -300