I think there are two problems:
a) a circular reference (please have a look at the table viewer CTRL-T) - I solved this by concatenating the order and forecast table
b) for orders, only product# are given, after concatenating, the link to product family is missing - I solved this by applying a mapping from product# to product family in product table also.
Please have a look at the attached.
Reseller2.qvw 165.0 K