count the count

[#1]

Hello,

i have the attached file,

It displays the count of each ID has.
How can i further to calculate how many IDs are having the count of 1, 2, etc?

i can easily do this in excel pivot. i'm not sure how in QV.

If someone is able to show it in the file, that'd be great.

Thanks

[#2]

Hi

see this

Thanks

zaman

[#3]

Count({$<Count={1}>}Count) and Count({$<Count={2}>}Count)

First expression will show the count of id's which have 1 as count and second expression which shows the Count of id's which have 2 as count.Count({$<Count={1,2}>}Count) which will displays the sum of count of id's which has either 1 or 2 as count .

[#4]

Hi Zaman,
Good suggestion, but i overlooked one thing. The count column in my souce is actually a count(), but in the example, i hardcoded the count result. and when i do count(col1) in Dimension tab, it doesnt work.

Hi Naive,
We are still on v8, set doesnt work for us. but i'll try as soon as v9 is up.
Thanks.