If you want the Subtotal value to be the sum of Sales values only for "1/31/2013", then try something like :

=Sum(Iif(Fields!MonthEnd.Value="1/31/2013",Fields!Sales.Value,0))

Regards,

Uma

First you may have to modify your query so that the MeasureDescription field is in HTML format.

Something like:

SELECT 'M1' as Measure,

'Description: <a href="http://www.google.com">Description for M1</a>' as MeasureDescription

Then in the...

You could add a new dataset in your main report itself. In this dataset query, you could write a SQL query that would effectively sum up the required data. You...