05-30-2014 04:53 PM
By default, Visual Analytics reports sort categories alphabetically, so Turmeric 1kg will come before Turmeric 500g, for instance. It looks like you need a custom sort order so that Turmeric 1kg comes after Turmeric 500g. You can achieve a custom sort using a numeric underlying column as a category data item that displays a custom user defined format. Note that the next release of Visual Analytics will give you a way to define custom sorting for any category data item in your report. Even then, user defined formats still could be best option for custom sorting when the category has many distinct values and where the custom sort is needed on many reports.
The following is pasted from a page in the SAS Visual Analytics 6.4 User’s Guide, http://support.sas.com/documentation/cdl/en/vaug/67270/HTML/default/viewer.htm#p0uroboxihl12on1pzzkf...
I hope this helps.