AnsweredAssumed Answered

Report with sum for various salesmen

Question asked by ssurma on Nov 26, 2012
Latest reply on Nov 27, 2012 by ssurma

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:

 

ManufactureJohnScottDaveTotal
Apple



Bacon



Cheese



Dates



Eggs



Flatbread



Ginger



Hops



Indigo



Jokers



Limes



Milk



Necterine



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?

Outcomes