Hi All,
I created this calc in which i have created a string from order date however i am not able to order from smallest to largest for e.g when i select monthly from Choose trend parameter it should Jan2017 to Dec2017 and same when i select quarterly it should should Q12017 to Q42017. This should also work if more years are selected for e.g. 2016 and 2017 etc. I am attaching my sample workbook here in which i have emulated my problem using superstore data.
Hi Shariq,
Click on the Trend Calc and select sort
Select ascending and select sort using field, select date from drop down and select aggregation as minimum
Click OK you can see the sorting happen correctly
Monthly View:
Quarterly View:
Hope this helps kindly mark this answer helpful/complete so that it will others
