Group with After Count Number

[#1]

Hi,

I use a expression to coun(TicketNo).

for example:

TicketNo          =count(TicketNo)

    1                          9

    2                          9

    3                          10

...

how can i group all count(TicketNo=9) in one... so that when i can click 9 it will show me 1 and 2

Thanks

[SunilChauhan]

please see the attached file.

hope this helps you

[#3]

but now my situation is i do the count from the expression count(ticketNo) where i wish to group for the result not define by me...

[its_anandrjs · Accepted solution]

Hi,

Make a new resident table and create a field there with count(ticketNo) and use this field to group

Rgds

Anand

[SunilChauhan]

see the attached file

hope this help you