I am working through a problem and having some difficulty getting the result I am looking for.
Below is a simple table of what I am trying to achieve.
What I am looking for here is the top number of sales by hour and day per listed merchandise division. The goal would be to sum the orders by hour and day and output the hour and day which had the highest number of sales per division. I would also like to list the top hour across all division and days within the table as well.
I've tried a few set analyses but I think what I am trying to achieve is a bit more robust then I can handle.
Is there a way to just return the highest value per division.
For example, the Accessories category has the most revenue during hour 4... I would then want to see what day has the highest revenue regardless of the hour. So the accessories table may look like this:
Top Order Hour
Top Order Day
In All Division / Hour
In All Division / Day
I guess this could be achieved by a sort using what you provided.