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 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 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.
