1 Reply Latest reply on Feb 5, 2013 9:04 AM by Tracy Rodgers

    overlapping text with joined data

    Keith Larson

      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?

       

      Thanks.