AnsweredAssumed Answered

Filtering with a relationship

Question asked by nkolios on Dec 17, 2012
Latest reply on Dec 18, 2012 by nkolios

I have a table containing sales information. About a dozen sales categories, split into months over a period of 3 to 4 years. I am trying to create a table occurance for each year so I can run reports on that data. So I create a self join and join the tables using a global field in the main table and a field containing the year number on the secondary table. I have then created a crosstab report for the resulting data, the crosstab works great but the self join does not work and gives me all the sales data together and not one year at a time. I thought this method of self joining would reduce my data set by only showing data for year 1 or year 2 etc, but it does not seem to be doing this, am I missing something here?