-
Jan 24th, 2018, 09:19 PM
#1
Thread Starter
Lively Member
[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
-
Jan 25th, 2018, 12:18 AM
#2
Thread Starter
Lively Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|