I have an FM 11 file with a few tables, one of which is sales_tracking.
I need a way to report monthly totals of the sales data for each of the 11 manufactures for each of the 3 salesmen, so that one report will look liek this:
Of course the numbers would correlate.
I have tried a repatoionship and am able to see the montly totals by manufacturer, but not individual salesman. What am I missing?