using calculation condition in pivot table

[#1]

Hello,

I need to refresh the pivot table depending of the ActiveDocument.GetApplication.InputBox statement in a module.

I tried to insert an expression (ex. [Sales Amount] > Variable) in the Calculation Condition text box but nothing happens.

I would expect to see the pivot table contents filtered by the above condition depends of the user input.

Is it possible?

Thanks in advance.

Best regards