Collections Reporting Using Power Pivot
Level: Beginners
I was helping a user at http://powerpivotforum.com.au with a question about collections reporting and thought it would make a good blog post. There are a few interesting concepts involved which I will explain as I go along.
The scenario is as follows. We have 2 tables – one table contains all invoices (the master list) and the second table contains the invoices that have been paid along with the payment date. Here is what the payment table looks like.