Sorry Joe, I'm not sure how that applies to my problem. I watched the first 10 minutes of the video but couldn't figure out how to apply it to my situation. Do I need to create a calculated field for the totals rather than use the quick analysis toolbar?
Make two sheets. They will be identical, except that one will have totals and one will not.
Give the user a parameter that lets them select whether they want to see totals or not. If yes, then swap in the one with totals. If no, then swap in the one without totals.
The video shows how to do sheet swapping between two sheets based on a parameter selection. That's what you would do too.