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!