Pivot Sorting

[yellowcabguy]

Have a Pivot table that has 2 columns

First column is name of Dog (currently in Alph order)
Second column is length of time at shelter in years.

want to sort the table by the second column (high to low)

Can't seem to figure it out

Any guidance would be helpful

Thanks

 

[pgc01]

Hi yellowcabguy

Assuming Name is row and time is data, please try

Right click on first column.
Field Setings>Advanced>Autosort options>Descending, Using Field: the time column

Hope this helps
PGC

 

[yellowcabguy]

Pivot sorting

Here is what I currently display. First column is dogs name and second column is how long they are at the shelter. I am trying to sort the list on that second column so I can get the one with the longest time at the top.

Alex 1.1
Alfie 0.1
Banjo 1.0
Banks 0.4
Bat Girl 0.6
Bebo 0.5
Bird 3.3
Blue 0.6
Boogie 0.4
Brownie 0.4
Buddy 0.2