1 Reply Latest reply on Oct 19, 2014 6:36 AM by philmodjunk

    Client Counts by Fiscal Year of Ticket Requests

    gregdc

      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