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?
One option is to create a Primary Group from the secondary source:
Use Customer Nbr from the Cust Number an Sales data source (using it as the primary source) and State from the Cust Nbr and State source. Then, create the Primary Group from State.
Hope this helps!