Working with Edit Query textbox
If you are familiar with Transact-SQL, the easiest way to modify the query behind your pivot table is to click on the table, then on the MMTools ribbon click “Edit Query”. This opens a text box within which you can modify the query.
When finished, click “Test” to do a test-run of the modified query. If an error is generated, make appropriate changes before testing again, or give up by clicking “Cancel”. Once you have a “Query Successful” result from testing, you can click “Save” to lock in the new query. Don’t forget to save the workbook before exiting to keep the new query in effect.