Hoping someone out there can help me with this one. here is my situation.
I have 3 fields
field 1 = customer number
field 2 = a numeric variable (Amount purchased if you will)
field 3 = 3 variables A, B, or C
Customer 1 – 1 – A
Customer 2 – 5 – B
Customer 2 – 7 – C
Customer 3 – 3 – B
In Field 3, given that in any row I can have either an A, B, or C I need to have, either via query or report, a way of filtering into a report that will list say Customer 2 as having purchased a total of 5 pears and 7 Oranges.
I hope that makes proper sense, I am still learning this package and I appreciate any help given ahead of time