Data sort then sort of same value in descending days of the week

Hi
I am looking for a some help please, I have a massive list of data that is part sorted, I have all data sorted in descending order from column B but I require to sort again in from column D in descending order (from Sunday) for each day of the week, for each group of store values that are the same. I have attached an example that would perhaps help clarify what I need to sort.

I am aware that I could select each group and do a custom list sort but I was hope there was a much quick way to achieve this.

Many thanks in advance

Jim

Hi

wondering if anyone could give me a a big bit of help for this data sort.

many thanks