Apologies if this has been covered already, but could not find anything on here.
Attached lists three hundred payments against invoices raised by companies.
Col E shows one hundred and forty seven of them were not paid within thirty days, so were "overdue" when paid.
Using Formulae, the Graph in rows 1 - 14 summarises the totals and the Table in rows 17 - 22 summarise invoices by month perfectly.
But I can't get the same result on the Pivot Table in rows 24 - 29. It lists ALL the three hundred transactions, even though it is linked to Col E?
All solutions, suggestions and alternatives welcome as ever.
Ochimus
Bookmarks