Pivot Table Ordering

  • Thread starter Thread starter Tony
  • Start date Start date
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
 
Click one of the vlaues in the Data field (qty sold). then do Data=>Sort

Select ascending or descending and click OK.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table help 1
Pivot table multiple filters 2
Pivot table drill down sort 0
Can PIVOT tables do this? 3
Unable to Group in Pivot Table 1
Pivot table formulas 1
How to determine order of row fields in pivot table 1
Pivot Table - Subtotal of 3 columns 1

Back
Top