Set Analysis

[#1]

Hi All,

I have only recently started to use Set Analysis for simple selections. I am looking for a steer as to how to tackle a particular challenge.

Given the below data set, how do I could the number of Projects (using Project ID) that have 0 - 5 open risks, 5 - 10 open risks etc.

Many thanks,

A

Data Set

Projects ID	Risk ID	Status
P001	16	Open
P001	15	Open
P001	14	Open
P001	13	Open
P001	12	Open
P001	11	Closed
P007	10	Cancelled
P008	9	On Hold
P008	8	Open
P008	7	In Progress
P008	6	Cancelled
P008	156	Closed
P008	4	Open
P014	30	Proposed
P015	2	Cancelled
P016	1	In Progress
P017	100	Open
P018	1	On Hold

Desired Output

0 - 5 Open or On Hold Risks	5 - 10 Open or On Hold Risks	10 - 5 Open or On Hold Risks	etc
# of projects by Project ID

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[Kushal_Chawda]

see the attached one

[#4]

Thanks G Wassenaar & Kush141087 for your help with this. Much appreciated.

I have used the solution provided by G Wassenaar. Whilst it was slightly different to my original request it is the most elegant solution to my current challenge, however I will need to use both solutions further down the line.

Thanks again to both of you.

A