By using this website, you agree to our Terms of Use (click here)
Hi,
I'm trying to do a pivot table with vendor ID, Vendor name and total amt.
I would like to sort by Vendor name (which is listed 2nd in the rows table) however it just keeps sorting by Vendor ID (which is listed first in the rows table).
Can it only sort by what is listed first in the rows?
Can someone advise what I am doing wrong?
Thanks!
Since Pivot Tables group by each field, it has to apply the sorting one group at a time. In your case, it's first sorting on Vendor, then on Vendor Name within each Vendor and, since there's only one Vendor Name within each Vendor, it doesn't look like it's sorting on Vendor Name at all.
My suggestion would be to add a Calculated Column to the Generic Inquiry that combines Vendor Name and Vendor into one field, then sort on that Calculated Column. You could use a formula like this for the Calculated Column to list the Vendor Name, then the Vendor in parentheses at the end:
=[Vendor.AcctName]+' ('+[Vendor.AcctCD]+')'