Count from Straight Table

[kenji_khoo]

Dear all experts,

Please refer to the table below: 

I can simply do a count(Detail No) to get the column 3.  But in column 4, I would like to have total count of Detail No by Group No. I tried aggr(count(Detail No),Group No), it doesn't work.   

Group No	Detail No	Count Detail No by Group No	Total Count of Detail No
		4
200270313	10	1	4
200270313	20	1	4
200270313	30	1	4
200270313	40	1	4

[tresesco · Accepted solution]

Try:

count( total [Detail No])

Or

count( total <[Group No]> [Detail No])

[Lisa_P]

It is giving you what you ask for.

What are you expecting to see ?