Is there anyway to get Smarten to sort the columns that way?
This can be achieved by using the relative time series feature. You can add same measure (SalesQty) multiple times
Add time series to the measure (SalesQty) like This Year, This month
Similarly, add time series to other measures like
and so on...
The resultant crosstab would be
Note: This article is based on Smarten Version 5.0 . This may or may not be relevant to the Smarten version you may be using.