I have two identical pivot tables with different sort order of th.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Two identical pivot tables referencing the same source file. However about
10% of the data is sorted differently i.e. the sort order varies. However,
the sum and count totals are identical. Why the variance in the sort order?
This can lead to big errors in the associated report, where the sort order is
important.
 
Perhaps one pivot table has fields set to automatic sort, and the other
has manual sort. To check:

Double-click a field button
Click the Advanced button
Select the same AutoSort options for all pivot tables
Click OK, click OK
 
You must log in or register to reply here.

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

How do I stop a Pivot Table from Sorting my data (Excel 2007) 1
How to sort data in excel 2000? 3
Pivot table sort 1
Arranging row titles in a Pivot Table 1
sort order of pivot table drill down 0
Pivot Table Data Column Sort Excel 2007 1
Pivot Table field selection order 5
Sorting Count Values in Pivot Table (Excel 2007) 1

Back
Top