Pivot Table Sub Sort

[pkelly]

Hi...

I have a pivot table which looks like the following (please excuse the data - this is sample data)....

It is currently sorted by the 3rd column (31/07/2004 sales) using the following expression...

=sum(IF(dor_OrderDate = varToday), sls_SalesAmount))

What I would like to do is first of all sort by the expression above then, for the accounts that do not have sales today, sort by their decending months sales i.e. 6th Column (Jul-2004 Sales).

=sum(IF(Month(dor_OrderDate = Month(varToday), sls_SalesAmount))

Is this possible?

Regards

Paul