How to Add Multiple Column Groups?

Question

How to Add Multiple Column Groups?

htt

SSCertifiable

Points: 5242
More actions
November 10, 2016 at 5:03 pm

#314787

Hi everyone,
I need to create a report showing the number of Failed/Passed tasks for a year. The report should have:
- a column for quarters
- a column showing total of passed tasks for each quarter,
- a column showing total of failed tasks for each quarter
- a column for months
- a column showing total of passed tasks for each month
- a column showing total of failed tasks for each month
The data set is below:
Quarter Month TaskName TaskStatus
11HPassed
11AFailed
12GPassed
13GFailed
13FPassed
13yPassed
24dFailed
24FPassed
24RFailed
25QFailed
25KPassed
25YFailed
26FPassed
26DPassed
The expected report is like this:
Quarter Passed Failed Month Passed Failed
------- ------ ------ ----- ------ ------
1 4 2 1 1 1
2 1 0
3 2 1
2 3 5 4 1 2
5 1 2
6 1 1
I am able to use column group to create a report with 3 columns for months as below. However I am stuck at adding column for quarters and column group that column similar to what I did for months.
Month Passed Failed
----- ------ ------
1 1 1
2 1 0
3 2 1
4 1 2
5 1 2
6 1 1
After I added another group by Quarter I can not see how to add new column group for Quarter to count Failed/Passed per quarter to meet the expected report. Is is possible to produce the report I want?
Many thanks!
Quarter Month Passed Failed
------- ----- ------ ------
1 1 1 1
2 1 0
3 2 1
2 4 1 2
5 1 2
6 1 1

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

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

doug.brown SSCertifiable Points: 5607 More actions · Answer 1

It would be formatted differently than your desired example, but if you just add total rows for your Quarter group, you should get something like:

Quarter Month Passed Failed

------- ----- ------ ------

1 1 1 1

2 1 0

3 2 1

Totals 4 2

2 4 1 2

5 1 2

6 1 1

Totals 3 5

htt SSCertifiable Points: 5242 More actions · Answer 2

Thanks Doug for your suggestion. I managed to use the wizard to create the report below. I did try the hard way and wasted time! However I still wonder if the format of the expected report is doable?

Thanks,

Passed Failed

--------------------------------

Quarter

1 4 2

--------------------------------

Jan 1 1

Feb 1 0

Mar 2 1

--------------------------------

2 4 4

--------------------------------

Apr 1 2

May 1 2

Jun 1 1