sales report sort and find

[joeloveszoe]

good morning!
i have a sales report that i am trying to sort filter and need some help
using these headers

Order Number

Time of Order

Customer

id like to find customs that have not placed an order in some time
any thoughts on how to do that?
thanks!

 

[Burrgogi]

We do not read minds here. When you say "....not placed an order in some time", what does in some time mean to you? 10 hours? 10 days? 10 weeks? You have the middle column labeled as "Time of order" so I assume the unit of time is hours rather than days.

Also, if you want a clear answer, you should post some sample data of taht's contained in the middle column "Time of order". Is it just the date or date & time? etc.

e.g.
5/29/2024
5/29/2024 12:00 pm

 

[joeloveszoe]

oops!

We do not read minds here. When you say "....not placed an order in some time", what does in some time mean to you? 10 hours? 10 days? 10 weeks? You have the middle column labeled as "Time of order" so I assume the unit of time is hours rather than days.

yes! you are right - sorry!
i'd like to see orders not placed sine march of 2022
thank you!

 

[Burrgogi]

oops!

yes! you are right - sorry!
i'd like to see orders not placed sine march of 2022
thank you!

That's not exactly a "Time" Those are months & years. Maybe you should relabel it to "Date of order". At any rate, try this:

Turn on auto-filter for your columns and use the "Date Filtering" feature. Example here:

 

[joeloveszoe]

That's not exactly a "Time" Those are months & years. Maybe you should relabel it to "Date of order". At any rate, try this:

Turn on auto-filter for your columns and use the "Date Filtering" feature. Example here:

View attachment 112049

so easy!!
i'll give it a try - i never noticed that date filter option!
thanks so much =)

 

[smozgur]

so easy!!
i'll give it a try - i never noticed that date filter option!
thanks so much =)

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.