Change calculated field in pivot based on option button

[dancing-shadow]

Morning - hoping this is a quick and easy fix!

I have an option button on the same sheet as a pivot table. The pivot table has two similar calculated fields currently

Within SLA % = 'Within SLA' / Projects
Outside SLA % = 'Outside SLA' / Projects

What I want is to toggle both calculated formula between /Projects and /Jobs by clicking the option button.

The code I currently have is not working:

With ActiveSheet.PivotTables("PivotTable5")
    .CalculatedFields("Within SLA %").StandardFormula = "='Within SLA'/Jobs"
    .CalculatedFields("Outside SLA %").StandardFormula = "='Outside SLA'/Jobs"
End With

Am I going about this the right way or is there a better option?

TIA

 

[kalikj]

Hi, I am not clear as to why you need an option button to accomplish this, as this can be achieved within the functionality available within the PIVOT table itself on the basis that the "Within SLA %" & "Outside SLA %" are fields within your base dataset?

 

[dancing-shadow]

The file is a template to produce a report. The sheets with pivots are stripped out and sent to the client, so they a dashboard type view with the option button to change the view on the pivots to see the figures at job or project level without needing to change formula's themselves (as they simply don't have the knowledge to do so!)