I have two data sources linked by Customer Number. In file #1, I have Sales data by Customer Number and in file #2 I have State for each Customer Number.
I'd like to see the Sum of Sales for each State. However, when I try to make a cross tab I have overlapping text since I am putting Customer Number on the detail shelf, in order to link the two data sets.
How can I fix this so that I get the Sum of Sales by State?