OldManExcellor
New Member
- Joined
- May 30, 2011
- Messages
- 45
I try to sort a row label column in a pivot table by an average of value.
I click advanced sorting and choose the average of value column.
But the darn row label is sorted by sum of value column anyway! Is there any way to "fix" this?
I'd like to do this in VBA if possible. Hope you can help!
I click advanced sorting and choose the average of value column.
But the darn row label is sorted by sum of value column anyway! Is there any way to "fix" this?
I'd like to do this in VBA if possible. Hope you can help!