H4K (10/15/2012)
For 2nd table, what is the expression for showing year where error occurred ?I mean there are 3 years from 2009 to 2011. So which of them are you trying to show in the year column ?
And also the sales values in 2nd table for those 3 years don't match with the 1st table ?
The year column has the following expression:
=Sum(IIf(Fields!Year.Value > 2008 And Fields!Year.Value < 2012 , Fields!Sales.Value, 0))
It is poorly titled, the column should be called '2009-2011 Sales'. I want to get the expression working first before I worry about properly titling my columns 🙂