there are ways you can create a desired result set using custom grand totals and placeholders instead of using actual cross tab.
It gets very complicated. I would rather prefer the simplicity of additional worksheet.
Book2.twbx 2.4 MB
Find the attached workbook and data source I have used , in order to get the O/P you need to create two sheets one with normal data and other with total with adhoc calcualations
Mark the solution as helpful/correct if it resolves the issue so that it will be helpful to others