Pivot Table Number Formatting based on Filter selection

[iosiflupis]

Hello all,

I have a pivot table that is pulling data from a separate spreadsheet. The filter that I am using has three selections: one should be in a number format, and the other two should be in percentage format.
I have tried to format the numbers in the pivot table in each of the selections to the respective format, but when I go from percentage slice to number slice the percentage formatting remains. This happens going in the opposite direction as well. I have searched all over to see how to get this to adjust based on the filter selection and cannot find anything to assist.

I would like to stay away from VBA as this sheet will be used by others and will most likely live on after I have gone.

Thank you all,

Joseph Carney