Forum Discussion

BoostNest's avatar
BoostNest
Frequent Visitor
9 years ago

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 ...
Need Help
BoostNest's avatar
BoostNest
Frequent Visitor
9 years ago

Thanks again Michael for your reply, we are running OS X so am trying to get a solution without having to use windows VM.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

 

  • BoostNest's avatar
    BoostNest
    Frequent Visitor
    9 years ago

    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?