Forum Discussion
Convert Pivot Table with Calculated Field to SUMIFS Table with Dynamic Headers
I have a pivot table with 3 filters, Date grouped by month in Columns, County in Rows (12 selections) and "Sum of TIV Rate" in Values. The Values field selection is a calculated column. It takes ...
mmarino3 Can you give an example of what the data would look like like:
| Column A | Column B | Column C |
| 1 | 2 | 3 |
| 1 | 2 | 3 |
I have a very similar table i think with a Sumif that is looking at the Pivot and is also only calculating if the "Payer" in my Pivot is a certain Value so that I can expand the Calculations out multiple columns using multiple IF and Sumif nested formulas.