try this from Development environment only. Tricky to do in N-Printing.
Do your sorting in your Qlik Sense/Qlik View chart not in nprinting.
In Qlik its in sorting order only means Feb2017,jan2017,dec2016,nov2016 .in desc order it is there in qliksense
but my out put excel template is coming like above.
i dont have ant value list for the month field.
MonthName(MakeDate(if(PERIOD>9,FISCAL_YEAR+1,FISCAL_YEAR),if(PERIOD>9,PERIOD-9,PERIOD+3),'1')) as [Month Name]
I notice there you have a piviot table in sense.
Last time i tried it the piviot table wouldnt convert to a table could only bring in as an imagine into nprinting. Is that not the case now? Im on 17.3.
If you are bringing it in as an imagine then sorting shouldnt be an issue. If you are importing a table try bering in just the table object and keep its formating no customising of the individual columns.
i created empty excel temple with pivots with data first then after i deleted data and done the refresh all,
then it will be empty template with layout pivot . when we drag objects in designer the out put coming like that.
I mimic but do not use a piviot table in my (Nprinting dedicated) Sense app but using a straight table then brought it into nprinting as a straight table. It took more effort to setup but allowed me to bypassed the sorting and layout issues I just brought it in as is.