ChrisG

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

Outcomes