Table with Groups with "certain conditions"

ad

Hi,

 

I have a question :

 

For a dataset like this :

 

Group	Score
A	80
A	34
A	67
B	21
B	97
B	88
C	87
C	56
C	61

.........and so on 

 

I want to create a table which shows Group (A/B/C etc.), and "number of rows" with Scores between a certain range like 80< Score < 100 for each Group. 

 

 

 

 

 

 

Jeff_Perkinson

I would use the Formula Editor to create a new column to indicate that a row met the condition and then use that new column along with your Group column in Tables->Summary in the Group role.

 

 

Group	Score	Score in Range
A	80	No
A	34	No
A	67	No
B	21	No
B	97	Yes
B	88	Yes
C	87	Yes
C	56	No
C	61	No