MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 184|Reply: 1

Pivot Sort by values in FIXED Selected Column

[Copy link]

1

Topics

2

Posts

11

Integral

Member

Rank: 2

Integral
11
Post on 2-7-2017 07:06:17 | All posts |Read mode
Hello.
I hope someone can help me as this is driving me crazy!
I have a fairly simple pivot table (linked to an external source). It has date in Mth-yy format (sorted by newest (left) to oldest) in column headings, Brand in Row, and some brand share value in Values.
I have selected it to sort Brand (rows) by values in selected column $D$5.  This works fine, however when I refresh the pivot table and more months are added, the reference changes so its still sorting by the original month above (eg $E$5).
I need to always sort by the latest month - which will always be column D.
Any help would be greatly appreciated!

Oh and another weird point - I have another pivot in a separate workbook which is almost identical, and this one does fix the reference when refreshed!!
I've gone through all the pivot options etc, and cannot seem to find anything different.
Thanks
Reply

Props Report

1

Topics

2

Posts

11

Integral

Member

Rank: 2

Integral
11
 Author| Post on 2-8-2017 12:43:09 | All posts



Still no luck with this and I seem to have exhausted all avenues.
I've checked all Excel Formula and Advanced options and all are the same on both workbooks, as well as all Pivot table options, and making sure the design is the same etc.

I've had to come up with a workaround - some pivot change code that automatically sets resets the 'Sort by values in column' to $D$5 after each refresh.
Simple enough and does the job, but ideally I'd like all my reports to work in a standardised way. And more to the point, its just frustrating I cannot work it out!!!
If anyone has any thoughts, I'd be most grateful. Thanks
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-24-2017 21:36 , Processed in 0.242998 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!