SUM VALUES BASED ON IIF CONDITION in RDLC REPORT

Hi ,

you can use below query for your data set;

Select Nature,SUM(Pay) as Pay
  from tableName
group by Nature

in tablix bind Nature and Pay Column .

Go to Details group in Row Group- > Add total-> After.

Thanks

---

Please Mark This As Answer or vote for Helpful Post if this helps you to solve your question/problem.