Convert Pivot Table with Calculated Field to SUMIFS Table with Dynamic Headers

Copper Contributor

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 one field in the dataset and divides it by the other, then multiplies it by 100. I want to create a SUMIFS table for more flexibility. How can I do this?

 

Thank you.

1 Reply

@mmarino3 Can you give an example of what the data would look like like:

 

Column AColumn BColumn C
123
123

 

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.