I use a expression to coun(TicketNo).
how can i group all count(TicketNo=9) in one... so that when i can click 9 it will show me 1 and 2
please see the attached file.
hope this helps you
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...
Make a new resident table and create a field there with count(ticketNo) and use this field to group
see the attached file
hope this help you
Retrieving data ...