Client Counts by Fiscal Year of Ticket Requests
My table in FM 13 Pro are:
Client(ClientID,.....) ---< Ticket(TicketID, ClientIDFK, DateReceived, Fiscal Year Received....)
Client ID is unique, It is related to 0 to Many Tickets, Ticket have a Date Received (Calculated Fiscal Year)
I need to generate a report that shows the following:
Fiscal Year # of Unique Clients with tickets in this year
I have tried a lot of combination for Summary and Total Fields on both Client and Ticket but I do not get the right counts (ran the problem on a spread sheet so I know what to expect)
Would someone point me in the right direction, please?