Total Vendor Payments for 2013 for 1099 Reporting | CLEARIFY

Hello.  I would like to use QQube to pull the amounts we paid to each of our vendors during a specific date range (in this case all of 2013).  We need to use this report to create 1099-MISC statements for our vendors.  Can someone help with the proper setup for a PowerPivot table?  Thank you in advance!

Matt

We have attached an example for you, using the General Ledger Detail subject.