Forum Discussion
Month & Year order
Hi would appreciate some help. We are currently limited to usingt he app only not desktop so some of the other solutions don't/can't work for us. We are trying to create a sales report that show ...
Yes, I understand you don't want to use Desktop.
So I propose that you create a new column in your CalendarTable
=FORMAT(CalendarTable[Date],"YYYYMM") and use this column in your report instead of the current one.
So you will get the months ordered properly: 201611, 201612, 201701 etc.
All this you can do in the online Service
Thanks Michael, looks like an excel formula. I can't see anywhere in the Online app that allows you to enter those, simply edit and apply filters to the Xero dataset, which itself doesn't seem to be able to be edited.
I've had a bit of a google and it appears that you either need to edit in excel with the updates (windows) or use desktop. Is this what you mean?