E
exceltwister212
Is this possible? Sorts seem to be for the titles rather than the data.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
V
VancitysFinest
Right click on the field you want sorted, Field Settings -> Advanced ->
change the AutoSort options using whatever field you want to sort by.
change the AutoSort options using whatever field you want to sort by.
S
Smonczka
You can also highlight any of the fields in your table and then select
top ten from the Pivot Table menu bar. Then sort accordingly.
Vancitys sugestion will work but will change back to the original sort
once you refresh the data.
Smonczka
top ten from the Pivot Table menu bar. Then sort accordingly.
Vancitys sugestion will work but will change back to the original sort
once you refresh the data.
Smonczka
V
VancitysFinest
Hmm, I don't seem to have that problem Smonczka.
I have pivots I refresh every week and it remembers the sorts (and I
have 2 levels of sorting on the one pivot).
I have pivots I refresh every week and it remembers the sorts (and I
have 2 levels of sorting on the one pivot).
V
VancitysFinest
Hmm, I don't seem to have that problem Smonczka.
I have pivots I refresh every week and it remembers the sorts (and I
have 2 levels of sorting on the one pivot).
~ Victor Lai
I have pivots I refresh every week and it remembers the sorts (and I
have 2 levels of sorting on the one pivot).
~ Victor Lai