Grouping dates in Pivot Table that has blanks

Hi all,

I have a pivot table that pulls data directly from Microsoft Dynamics. It pulls all prospects (won, lost, open)... I am trying to group prospects into months by the "won date", I realise that means that the open prospects will have an empty "won date" field... so I can't just group them as you normally would. This means I need to regularly go into the report and group them manually.

I was wondering if there is a macro that would group these automatically for me... any thoughts?

Thanks!

Can you upload a sanitized sample file?