top of page

Total Spend by Supplier and Month - Last 12 Months

Total Spend by Supplier and Month - Last 12 Months

This question uses a pivot table to display your total spend per supplier per month.


Once you have built the question and visualized it, click on the Settings button at the bottom of the screen and then on Pivot Table Options. Drag the Date Invoice field into the table columns area like so:

ree

A nice feature of a report like this is that you can click on any cell in the table to drill down in to the data. It will generate a new report with the individual transactions for that supplier in that period.

Thanks for subscribing!

© 2025 Pro Suite. All Rights Reserved.

bottom of page