SSRS Table - 2 Dataset Comparisons

Hello -

I have a drilldown table in a report that looks at call data from one datasource (company -> year -> month -> calls). I am trying to use an IIf statement in the table to look at sales for those related months in the same table. This data is in a different datasource.

If I just throw in a sum(sales), it retrieves the correct total sales, but I want to match up on the drilldown month.

I end up with an aggregate function not allowed in scope.

Thanks!

1. works in "Calls" Table - retrieves total sales
2. ?

1.=Sum(Fields!total.Value, "Sales")
 
2.
=Sum(IIf((Fields!date.Value, "Sales") = (Fields!MidnighStartDate.Value, "Calls")), (Fields!total.Value, "Sales"), 0)

Select allOpen in new window