Dear FMP gurus
I have been trying with not much success to create a dynamic html crosstab report. I have found some samples and discussions on the net, but at this point it is a bit beyond me.
I need to build a crosstab report with the following data:
Y Axis = Customer names
X Axis = Product names
Chart = Quantities sold to each customer
All of this data resides in a single table called "distribution"
Up to now I have managed to create the X and Y axis, but getting the quantities to line up with the correct customer / product pairing has got me stumped.
Any help would be greatly appreciated.