9 Replies Latest reply on Jun 20, 2018 6:17 AM by Benedict Sebastian

# How to get a pane total as banner box within the same worksheet??

Hi,

I am trying to get a grand total as a separate box within the same work sheet . Is it possible ?

Grand total is affecting the scale which means bars in the attached bar chart are shrinking in  size. Ideally what I am trying to achieve is as below

• ###### 1. Re: How to get a pane total as banner box within the same worksheet??

Hi Benedict!

You can create a dual axis. Example is attached.

pls mark as correct and helpful

D

• ###### 2. Re: How to get a pane total as banner box within the same worksheet??

Hi Can you attach as  a 10.5 version

• ###### 3. Re: How to get a pane total as banner box within the same worksheet??

catch it +)

• ###### 4. Re: How to get a pane total as banner box within the same worksheet??

Sorry it still says created in newer version of tableau. I am currently on 10.5.3

• ###### 5. Re: How to get a pane total as banner box within the same worksheet??

aaaa

• ###### 6. Re: How to get a pane total as banner box within the same worksheet??

Thanks for the solution. However seems to be having trouble making it work when filters are applied as below ?

• ###### 7. Re: How to get a pane total as banner box within the same worksheet??

No, it's just LOD calc. You should use it in a proper way.

{Fixed [Filtered Dimension]: SUM([Sales])}

D

• ###### 8. Re: How to get a pane total as banner box within the same worksheet??

To get the total (without the Grand Total bar) just use .... WINDOW_SUM(SUM([Sales]))

But you can't create a separate box on the sheet, the only place you can really put something like that is in the title.

So I would create a calculated field called TOTAL (or whatever you're comfortable with), then add this formula to it:

WINDOW_SUM(SUM([Sales]))

Then drag that on to Detail and edit the title and add it in.

• ###### 9. Re: How to get a pane total as banner box within the same worksheet??

Thanks Chris. Tableau Ambassadors are amazing !!

1 of 1 people found this helpful