Here is a workbook that shows how it can be done.
The calculated field is TOTAL(SUM(Sales)). When included in the level of detail, it can be used in titles, captions, and tool-tips.
Grand Total in Title.twbx.zip 82.6 KB
I'm trying to replicate this, but I'm getting a range in the title instead of just the total number. I am using total(sum(value))... not sure how to work around this!
I was able to get this to work...I had the same issue as Amy, but when I changed the table calculation to "Compute using table(across) or table(down)" this solved the problem.
Any get this to work with the "Pages" card? It seems like once you do that, the title goes awry as it shows XXX to YYY as if it's doing a range of the low and high of the values across the pages.
You'll likely need to use the drop down on the field to select Edit Table Calculation... and in the resulting dialog box, select Specific Dimensions and check all of them:
Table across and Table down won't work if the dimension on Pages is not on Rows or Columns (defining the table).
The XXX to YYY range you see is the lowest and highest values of the TOTAL() calculation if it is partitioned by dimension values. By checking all the dimensions, you specify only one partition and thus only one value. You may have to edit your Title after you make changes as editing the table calculation tends to cause a <Missing Field>
Hope that helps!
Thanks so much Joshua. If you have already done this in a sample workbook, might you be able to attach it here please? I tried these combinations and I can't seem to get it to work as I still get the same number for each page.
I can also re-create this in Superstore for you to see if easier.