Hi, please help as I want to summarize personwise sales with payment received thru PIVOT Table as invoice date and month is different and payment received dat are different I want to summarize. Column should have monthwise details like Invoice and payment amount should come in the month when the payment came in same row against that invoice .