Is it possible to perform a Sumproduct in a pivot table? I'd like to see the weighted average interest rates grouped by a type of product. I can subtotal the data and manually calculate the sumproduct for each grouping. But I wasn't sure if there's a simpler way. I'm running Excel 2010.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sumproduct in a Pivot Table?
- Thread starter jkgreen
- Start date
