I am trying to get a count of Customers from a table a few relationships away
SalesLines – Sales – AccountNumbers – Customers
I have a subsummary report based on the SalesLines table which I am performing a find,
Product
Date Range (Sales)
I need a count from the found set of Customers, one Customer can have multiple account Numbers (that table contains the customerID)
A count of unique customer ID’s in the AccountNumber table would be fine.
I just can’t seem to get it to work.
If I am on the AccountNumber table, no problem I can use a summary field or an array of calc functions which all work well.
The problem is that I am filtering the list based on SalesLines & Sales.
Clearly there is a method that I have used in the past, but today it eludes me…
Any help is appreciated!
Powered by WPeMatico
Neueste Kommentare