This post is about using pivot table with excel 2007 with invoice payments received data from sql server.
In this case company’s payment mechanism was changed from full 1 payments to breakup in 4 to 5 payments. We created a new table named payments received and linked it to the Invoices table. Whenever payment for certain invoice received it is added in to payments received table.

The issue is now to create report which shows payments received against the respective invoices, we also used the cross tab report which shows invoice value and NO on row side and payment received and date on column side. We tried the same with excel 2007 and found it be more practical with more functionality.

Basically whenever any business rule change our database should be flexible to adapt a change and efficient tools, in our case Excel 2007 made the change easy to adapt.