Set Sorting by one of Series from Dashboard Chart

  • 1 December 2023
  • 0 replies

Hi everyone, I created a dashboard chart to show top 10 customers we billed this year vs. last year. The underlying GI is simply using the ARInvoice table to pull out all invoices with positive number and credit memos with negative numbers without grouping. I then added a new column using the Year () formula with DocDate to get the Year field. The widget settings are below.

However, the result seems to sort by the sum of this year and last year total. So it looks not perfect for our client.

Is there a way to setup the sorting by 2023? Please help!


0 replies

Be the first to reply!


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved