Hi, Experts
I want to know how to design query like that(By product):
CHAR:product
KF:P/O,Ship.Total Sales,inventory
-
Week1 Week2
Product A P/O 70 60
Product A Ship 60 75
Product A Total Sales 80 70
Product A Total Inventory 170 175
-
Week1 Week2
Product B P/O 60 50
Product B Ship 50 65
Product B Total Sales 80 70
Product B Total Inventory 170 175
-
....
Thanks,