I am scratching my head with this one... I have a report in a matrix (SSRS 2008 R2) which show 12 months of data. If we are in the month of September I show the actuals up through September then show the projections by month for the rest of the year. I need to total the row (9 Actuals + 3 Projections) but I'm falling flat. Anyone else have success doing this?

You could put this in the query: select actuals as amount, month from table union all select projection, month from tableRussel Loski, MCT

Refer to this similar thread http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/74c06d7b-1ea4-4d43-8532-ca5627ed1d4b Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Can you do a Union using a SSAS data source?

To SSAS data source, you could click this link http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/84735a26-eff6-4ec2-afed-dc51908bf99e/ Thanks, Challen FuChallen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.