Post reply

Calculating SUM with multiple groups

  • March 21, 2011 at 9:35 pm

    #236533

    Hi,

    I am stuck with calculating SUM for multiple groups, Below is the requirement.

    Query fields:

    DivName,Department,JoinDate,Emptotal

    Sample data

    Calc,software,2010-09-29,4

    Calc,software,2010-09-30,3

    jana,Hardware,2010-09-30,5

    blr,Hardware,2010-10-01,6

    Calculated fields:

    Year --> derived from JoinDate

    Month --> derived from JoinDate

    I am trying to create a report like below

    Department, Year, Month, EmpTotal

    Here the groups are on Department,Year,Month and i have to sum all EmpTotal.

    How can i acheive this in SSRS 2008

    Thanks,

    RK

  • March 22, 2011 at 7:18 am

    #1301861

    Write your query so that the detail returned is the SUM for Employee. Then in your groups simply drop your value field in the appropriate cell on the report and it will SUM appropriately for the group you drop it on.

  • March 23, 2011 at 4:01 am

    #1302349

    Thanks, That worked

    Thanks,

    RK

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply