How to Custom Sort specific Pivot Table.

Good Morning Guys.

My Pivot Table has 26 row labels.

I have set up Subtotals to None.
The Report Layout is set to show in Tabular Form and to repeat all items labels.

The row labels are already organized in the correct order. Company is the first row label. Transaction Date is the 11th row label.

Here is an example of what my pivot table would look like:

SEE EXAMPLE 1

Each Colum or ( Row Label ) has a drop down menu in which i can sort.

I can sort everything by Company using the dropdown button at the top of the list, but what i want is by company and then by transaction date and if possible transaction time.

I would like get together all the loads that each company did, organized by day and then by time. But i would like to leave the columns just like they are.

Something like this:

SEE EXAMPLE 2

It has to look plain and simple like this. That's that each Company wants. Basically the only filter that i will have is a slicer for Company so i can give the corresponding report to each of the companies.

I'm new at vba programming. If you give me a sub procedure i can copy it.

I've also tried more sort options, unchecking the Autosort..etc..

I spent a long time yesterday reasearching for an answer. I even watch videos on youtube but i couldn't find anything specific to what i needed.

Hopefully someone can help.



Thank you.



Eros.

Guys.


I have upload a sample excel file.

This will give you a better idea of what i'm trying to accomplish.

I would really appreciate your help.


Thank you.

I keep looking but i can't find anything.

I've been having to copy and paste the values of the table and then sorting everything but i really don't want to continue doing that.


Can someone please help ?