RE: Sorting on pivot table

Tim Rodman — Sat, 21 Oct 2023 00:00:13 +0000

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:

=+' ('++')'

Sorting on pivot table

mna10 — Thu, 02 Feb 2023 20:09:00 +0000

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?

3077

Can someone advise what I am doing wrong?

Thanks!

Sorting on pivot table - Acumatica Generic Inquiries & Pivot Tables

RE: Sorting on pivot table

Sorting on pivot table