Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Try:
count( total [Detail No])
Or
count( total <[Group No]> [Detail No])
Try:
count( total [Detail No])
Or
count( total <[Group No]> [Detail No])
It is giving you what you ask for.
What are you expecting to see ?