Help with Pivot Table Please!!

Hi,

I have created a pivot table that does 90% of what I want it to do... but need help with the end.

Currently, I have types of inventory (text) as my row labels, and dates as my column labels.
It then sums the inventory i will receive by date.

How can i get the row labels to be in the same order as the dates?
I would like the inventory text that is coming to the first date, to be on the first row.

Sorry if I did not explain myself well!

THANK YOU!
-S

Can you post the file?

I'm not sure what you mean by sort the Rows by the Date Column?

The Dates in the Column area of the Pivot are displaying in date order, then the 'Sum SKU' in the Columns area of the Pivot sum the SKU for those dates.

Can you illustrate a mockup of the Before & After?

Thanks

Hi Sajo90,

I've had a look at the file & I don't know of a way to get a Pivot table to do this each time it is refreshed.

Can I ask why you want it this way?

Cheers

The other way would be to write a Macro to run each time data is added to sort it as you like.

So there would be no Pivot involved.

The limitation to your first solution is what a Pivot would normally do & as far as I know, you can't get a Pivot to sort as you like every time - unless there was a Macro to adjust the Pivot - so you might as well just use a Macro on the source data.

So there are very few things you can't do in Excel if you use VBA to manipulate data beyond the normal limits of Excel.