AnsweredAssumed Answered

Client Counts by Fiscal Year of Ticket Requests

Question asked by gregdc on Oct 18, 2014
Latest reply on Oct 19, 2014 by philmodjunk

Title

Client Counts by Fiscal Year of Ticket Requests

Post

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

2012                  9843

2013                10840

........

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?

GregDC

Outcomes