Ranking data in a pivot table
Hi Chuck
Double click on the FieldAdvancedSortAscendingUsing FieldSum of value
--
Regards
Roger Govier
"ChuckW" wrote in message
...
Hi,
I have a pivot table based on an access query. I want to the results
based
on sales (in the data field) rather than Customer Name (in the row field).
Is there a way to do this? I don't have a field in the column row since
it
is month to date sales but I can add that as well if it would help.
Thanks,
--
Chuck W
|