Pivot table to sort by 2nd Row data field

A

adam

Hi all

Is there anyway I can have my pivot table sort the data
as the above?

In the row data field I have Invoice Number and Invoice
date (in that order) and I'd like it so that when more
information is added into the source destination and I
refresh the table it sorts it all by the Invoice date.

Any ideas?

Thanks

Adam
 
Top