Hi

I am creating a crosstab report - in pb2017 r2 - where I have items down the side and date across - as per below

item                 pieces

                       15 Jan        16 Jan  .......... Total 

sheets               50               40 ..............

Pillowcases        112             75 .............

duvets              48               39 ............

towels              210            160 ............

bath mat           45              35 ............

I want to add some columns at the end of the report - I have managed to add average and max using

crosstabavg(1) and crosstabmax(1)

But I also need to add a column that using the data for one of the items -  in the case above bath mat - and creates the ratios for each items - so in column 1 I would want to show sheets ratio ( 50 / 45 ) ( number of sheets / number of bath mats  15th jan )  and ( 40/35 ) ( number of sheets / number of bath mats 16th jan ) pillowcases ( 112 / 45 ) and ( 75 / 45 ) etc 

How do I reference the values I require / for each date and then the ratio for the totals

as always any help really appreciated

Andrew