Skip to Content
0
Former Member
Aug 28, 2007 at 03:40 PM

How to design muti-display in query? thanks

16 Views

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,