In Pivot table sort

K

Krish

I have sales data in a pvot table, columns Year/Month and in rows Customers.
I want to sort the customers by the highest sales dollars specific to each
year and not as combined. At present Pivot table only gives data in
descending order total sales dollars added for Year 1 and 2. Is it possible?
 
S

Shane Devenshire

Hi,

No. The pivot table never allows you to break up a row of data. So for
Customer A you can sort by the value in any one year but not by
simulataniously by 3 or 4 different years. If you want to sort in the way it
sounds like you are asking, you will need to do it outside of the pivot table.
 

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

Dates In Excel 5
Pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
Changing Pivot Table Value Field Labels with VBA 0
How to ignore a column of numbers in Grand Total for rows 1
Pivot Table Calculated Field 0
Pivot table sort 3
Pivot Table showing wrong data 1

Top