crystal version8 pervasive sql 8
I have a cross tab report which summarizes the item information by qty shipped and sales amount by month.
2/2005 3/2005 total
item A 120 10 130 qty
$235 $240 $470 salesamt
item B 12 110 122
$23 $250 $273
CustomerA 132 120 252
$258 $490 xxx
Can we sort the report based on the grand total of the quantity shipped?
I have a cross tab report which summarizes the item information by qty shipped and sales amount by month.
2/2005 3/2005 total
item A 120 10 130 qty
$235 $240 $470 salesamt
item B 12 110 122
$23 $250 $273
CustomerA 132 120 252
$258 $490 xxx
Can we sort the report based on the grand total of the quantity shipped?