Display the number of rows based on the field value

Hi Mandavas7,

If I understand correctly, you have already add a group grouped by EMP_Dept and you want to display the count for each EMP_Dept group in the report. After testing it in my local environment, we can add a total row inside group below, and then use runningvalue function to get the count value in the total row. For more details, please see:

1. Right-click the (Details) group to add a Total –After in the Row Groups pane.


2. Add the following expression to the textbox under the textbox which contains [EMP_No] field.
   
   =runningvalue(Fields!EMP_No.Value,Count,"EMP_Dept")

You can refer to the screenshots below:

If you have any more questions, please feel free to ask.

Thanks,

Katherine Xiong

---

Katherine Xiong

TechNet Community Support