If I have a view that has 4 fields (customer, product, product type, date - all the fields are not unique and can be both parent or child) For example:
customer product product type date
ABC BEEF FOOD 1/1/03
ABC SHIRT CLOTHES 2/6/03
BGH APPLE FOOD 7/7/02
BGH BEEF FOOD 7/7/02
CCC SHIRT CLOTHES 5/5/03
Can you show me how to use data shaping to select * the fields using 'product' as parent and select * the fields using 'product type' as child.