Calculate DEPARTMENT wise sal and TOTAL sal in SSRS

calculate salaries in SSRS

{Continue with previous}

Step 1: Find here there is only individual salaries but our aim is find Department wise SAL. So follow the steps

Step 2: Click on any field -->Click on Insert Row-->Outside Group -Above

Click 3: Select empty field( means where we want to print value)-->Select Expression...

Step 4: Write the expression then click OK

Step 5: Take a look there is a department wise salaries

Step 6:  Add one more row outside group below and write the ExPRESSION where you want to display the GRAND TOTAL then click OK

Step 7: Click on preview ,See the below image