Hi mlmcc
First, I dropped in the sales value from the GL table in the detail section which is o.k, then as soon as I dropped in the State from Sales table, the total sales value doubled up. I don't get it ! Why would it double?
I grouped the State using the Group Expert, but the total sales value for State had doubled up. This is where I don't understand why CR is multiplying the sale value twice. My theory is because there are two transactions (i.e., one from the GL table the other is from the Sales table), hence it shows the amount twice.
Would it matter if my datasource is an EXCEL file?
I'm stucked !!!
Main Topics
Browse All Topics





by: mlmccPosted on 2009-07-23 at 18:23:24ID: 24931720
That should work for the table linking. You probably don't need the customer code in the linking.
Group by state
Insert the SalesValue and M2 fields into the detail section
Right click them one at a time
Click INSERT --> SUMMARY
Make sure it is type - SUM
Put it in the STATE Group Footer
You can hide or suppress the detail section
mlmcc