Skip to main content
Question

Set Sorting by one of Series from Dashboard Chart


Forum|alt.badge.img

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!

 

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings