Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having an issue with sorting a legend for a particular chart. It's sorting DESC, but what I'd really like to do is sort it based on the count of records. I tried changing the dimension to a formula hoping it would work, but it just returns an error. The formula I tried was =Dual(PRODUCT,Count(ID)). I hoped that this would count the records associated with each PRODUCT, but it didn't work. I thought I could then sort the legend numerically on the PRODUCT field
I can't attach the file unfortunalety, but I did mock up the chart to clearer define what I'm loking for. As you can see, the legend should be sorted by the numeric value after the product name (the numeric value doen't need to be present in the legend, it's just there to illustrate the sorting). Currently the legend sorts alphabetically DESC by the product name.
Thanks
Go to the Sort tab
In your Chart properties
Thank you for the reply. That helped switch the order to ASC alphabetically, but I still need to have it sort based on the total counts for each product.
Go to the Sort tab
That did it. Thnk you!