How to select/sort on column in pivot table
599321Apr 21 2009 — edited Apr 22 2009I have an Answers request with Year, Country and Tons. I have a pivot table with Country in the rows, and Tons by Year in the columns. I want to sort by tons for the rightmost year. I haven't found a way to sort on a single column in the pivot table output.
I can select a given row number using something like $1 or $2. I don't know if there is a similar format that lets me access column values that might help with this.
Each row in the Answers request has Year, Country and Tons. Sorting by tons in the Answers request sorts by values all years, but I need the data sorted by the rightmost year in the pivot table, so sorting by tons for all years does not give the correct results.
Thanks very much.