Here is what I am trying to acheieve:

One dataset with Sales Rep Name, Sales For each Month for said Rep, Target for each Month for that Rep, then two columns one that contains the month name and one the year for that particular row. These last two coulms have been made using DATEPART and DATENAME of a field in a view called Customers Required Date AS 'SOMonth' and 'SOYear'

The Dataset will eventually be limited by...