Pivot Table Ordering

T

Tony

Hi,

I have a very simple Pivot Table with 2 dimensions and a single measure.

Page Field : - Store
Row Field : - Product
Data Field : - Qty Sold.

I want to order the pivot table by Qty. I am able to order by Store or
Product but every time I attempt to order by Qty I get the message

"Cannot Determine which Pivot table field to sort by"

How do I do this?

Thanks in advance
 
T

Tom Ogilvy

Click one of the vlaues in the Data field (qty sold). then do Data=>Sort

Select ascending or descending and click OK.
 
Top