How to show a hidden field in Excel Report?

How do I pull a hidden field in an excel report?

I have created a calculation at the bottom and entered in all the formulas needed. It works but I do not want the guests to be able to see the total. I need the total in the excel report for myself. How do I have the calculations pull in the excel report without letting the guests see the number?

Thanks!

The hidden field should show in the Excel Report.
If the Excel Report was created before adding the hidden field, then it will not show.

Please create the Excel Report after adding the field.

Let us know if you need further assistance.