I want to create 2 reports from table such as below.
Tble
Cust Prod Sale$ date
abc a1 10 200010
abc b2 20 200105
abc c3 10 200208
bcd a1 30 200204
def c3 10 200006
I want report like this
cust 2000 20001 2002
abc 10 20 10
bcd 0 0 30
def 0 0 10
another report like this
Prod 2000 2001 2002
a1 10 0 30
b2 0 10 0
c3 10 0 10
Should I create query for each year and join them together or is there other simpler way. I think this should be very easy but I don't know how. Thanks for any input^^
Tble
Cust Prod Sale$ date
abc a1 10 200010
abc b2 20 200105
abc c3 10 200208
bcd a1 30 200204
def c3 10 200006
I want report like this
cust 2000 20001 2002
abc 10 20 10
bcd 0 0 30
def 0 0 10
another report like this
Prod 2000 2001 2002
a1 10 0 30
b2 0 10 0
c3 10 0 10
Should I create query for each year and join them together or is there other simpler way. I think this should be very easy but I don't know how. Thanks for any input^^