Re: How to display filtered pivot table when click on a text box object.
Add a Select in Field action (to select Group = 'A' or 'B' respectively) and a Set Variable action to toggle a variable value. Finally, use the variable in the pivot table's conditional show expression.
You could dispense with the variable if a selection on Group is enough to control the visibility of the pivot. Use something like this in the Show condition:
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein