You can use SUMIFS, SUMPRODUCT, and all other functions with Pivot Tables for your reporting. You're not limited to GETPIVOTDATA. Here's how to do it.
