6 Replies Latest reply on Dec 5, 2018 12:31 PM by Eric Viglotti

# inserting a grand total in title

Hi all,

Any idea if you can insert a grand total into a title? I have a graph and in that graph, I want the title to show the grand total of the \$ value in that graph.

My idea was to insert a calculated field into the chart with the grand total as that field, but I don't seem to be able to add a calculated field.

Any thoughts?

• ###### 1. Re: inserting a grand total in title

Saken,

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.

Regards,

Joshua

2 of 2 people found this helpful
• ###### 2. Re: inserting a grand total in title

Hi Joshua,

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!

• ###### 3. Re: inserting a grand total in title

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.

• ###### 4. Re: inserting a grand total in title

Hello,

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.

Thanks.

• ###### 5. Re: inserting a grand total in title

Eric,

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!

Joshua

• ###### 6. Re: inserting a grand total in title

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.

Thanks!