So I had to create a calculated field for my pivot table which is the sum of column A / sum of column C. My issue is i would also like to make this into a filter but it wont allow me to, I keep getting the field you are moving can not be placed in that pivot table area. I need it to be both a Value and a filter any help is appreciated thanks.