Results 1 to 2 of 2

Thread: [RESOLVED] Sum of individual values of a grouped columns.

  1. #1

    Thread Starter
    Lively Member FunkySloth's Avatar
    Join Date
    Aug 2016
    Posts
    91

    Resolved [RESOLVED] Sum of individual values of a grouped columns.

    Good Day,

    Let me show you a sample of my dataset records first:

    DEPARTMENT POSITION STATUS

    DEPT 1 - POS 1 - COMPLETED
    DEPT 1 - POS 1 - PENDING
    DEPT 1 - POS 2 - COMPLETED
    DEPT 2 - POS 1 - COMPLETED

    So I already group the department, position column and count the total number of request per position type giving me an output of:

    DEPARTMENT POSITION TOTAL REQUEST

    DEPT 1 - POS 1 - 2
    - POS 2 - 1
    DEPT 2 - POS 1 - 1

    As you can see the reason why POS 1 of DEPT 1 got a total of 2 request, because I have two instance of POS 1 under DEPT 1 in my dataset. But now what I'm trying to achieve is count the STATUS per position type, an output something like this:

    DEPARTMENT POSITION TOTAL REQUEST COMPLETED PENDING

    DEPT 1 - POS 1 - 2 - 1 - 1
    - POS 2 - 1 - 1 -
    DEPT 2 - POS 1 - 1 - 1 -


    Can anyone help me about this, I'm having a hard time figuring out how to implement this in SSRS.

    Thank you

  2. #2

    Thread Starter
    Lively Member FunkySloth's Avatar
    Join Date
    Aug 2016
    Posts
    91

    Re: Sum of individual values of a grouped columns.

    I finally figured it out .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width