Sorting on a 12 month rolling report

Modified on Wed, 6 Mar at 11:24 AM

Sorting on a 12 month rolling report. I would like to have the columns sorted across the page in the following fashion:

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.x . This may or may not be relevant to the Smarten Version 5.x you may be using. 

 
Time Series 12 month rolling Relative time series

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article