Say the current PT source data is named (non-dynamic) MyData
Put a header above the single cell. Give it a non-dynamic name also. Say, MyCell
There will now be two named ranges. MyData with headers & data and the small table MyCell that has a header and one data item.
Manual approach. Create a pivot table from a new Excel file. At the first step of the wizard (ALT-D-P) choose the external data option. Follow the wizard to the end and choose the option to edit in MS Query. Edit the SQL to suit. Obviously the SQL will be specific to your set up. Its form will be something like,
(Though a little more complicated as the calculated field is a percentage of a subtotal.)Code:SELECT M.your fields FROM MyData M, MyCell C WHERE [your calculated field] > C.[field name]
Complete the pivot table and move the resultant worksheet into the source data file if you want.