Dynamic HTML crosstab report

Discussion created by ChrisG on Nov 6, 2013
Latest reply on Nov 6, 2013 by ChrisG

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.


Thank you.


Chris G