Dear All,

I have an issue in crosstab by providing a running percentage, im using CR 2008.

in my row name i have the vendor name while in my column i have the month sales.

Per vendor their are several invoices which has the the net and gross price and 1 vendor can consist of more than several invoices.

how to get the the percentage for each vendor the total net/gross price of invoices?

e.g
           Month 1     Month2    Month 3     Total
Vendor A
Vendor B
Vendor C
Total      


Hope that you could help me...

i tried the gridvalueat function and it works but my concern is the alignment since its not necessary to show the net and gross price of the total invoice per vendor.

is their anyway i can just sum(net) % sum(gross)?!?!