11 Replies Latest reply on Jan 23, 2017 1:56 AM by irit fed

# Bar Graph Grand Totals - show just Total (Text) for the Grand Total instead of the Bar

I have attached a sample workbook.  Is there a way to just show the Value (Text) for the total for the Sales and Profit columns since the totals are so large that it is skewing the display of the Sales and Profit by Customer?

• ###### 1. Re: Bar Graph Grand Totals - show just Total (Text) for the Grand Total instead of the Bar

Hi Jackie,

I'm not sure I understand the question. Would you be able to go into more detail or provide a screenshot that points to what you're describing?

Thanks!

-Tracy

• ###### 2. Re: Bar Graph Grand Totals - show just Total (Text) for the Grand Total instead of the Bar

Hi Tracy,

So I'd still like to show my column Grand totals, but I just want to display the Grand Total and not the bar to go along with the Grand Total.

In this example, Totals for both Sales & Profit (\$14,915,601 and \$1,521,768) cause the bars by Customer to look really small and can't see the variation by customer this way.

I'd like the bars by Customer to look like this, but with just a Total for all Customers at the Bottom without the Bar to go along with the Totals.

Hopefully that helps.

• ###### 3. Re: Re: Bar Graph Grand Totals - show just Total (Text) for the Grand Total instead of the Bar

Hi Jackie,

See the attached. It uses the MIN/MAX technique from http://drawingwithnumbers.artisart.org/customizing-grand-totals-part-2/ to build a custom measure for the bar length (that is 0 in the Grand Total row), and uses the original measure for the label:

Jonathan

• ###### 4. Re: Bar Graph Grand Totals - show just Total (Text) for the Grand Total instead of the Bar

Hi Jonathan

Thanks for the post! This perfectly works fine in the absence of actions - if I have 'Select' actions ON for any one of bars and I SELECT one of the bars, the grand total text converts into a bar.

Any workaround for that?

Thanks

Amey

• ###### 5. Re: Bar Graph Grand Totals - show just Total (Text) for the Grand Total instead of the Bar

I don’t know how to duplicate the behavior, can you provide a sample workbook (.twbx) that demonstrates that and then I can take a look?

• ###### 6. Re: Bar Graph Grand Totals - show just Total (Text) for the Grand Total instead of the Bar

Hi Jonathan,

I guess he is facing this:

So if you have only one value, min=max  is true also for grand total

• ###### 7. Re: Bar Graph Grand Totals - show just Total (Text) for the Grand Total instead of the Bar

Thanks Ville.

Yes Jonathan, that’s exactly what am saying. I have attached your workbook with a Dashboard. It has a ‘filter on SELECT’ for Department.

So, if you click on any Department under Sheet 3, values of Sheet 1 and 2 will show corresponding values but the Grand Total below them changes to a bar.

I’ll hunt for the solution and post if I get lucky.

• ###### 8. Re: Bar Graph Grand Totals - show just Total (Text) for the Grand Total instead of the Bar

I didn't dig into Jonathan's suggestion, but maybe you could create a second sheet that creates your totals (WINDOW_SUM or something like that.)  Use all the same filters, but just calc up the totals and display them in a separate sheet, artfully positioned on a dashboard to look like grand totals...  Then you can display the data sheet one way, and the totals sheet some other way, and you'll get the behavior you want.  You can even have your SELECT action work on both sheets from the dashboard.

• ###### 9. Re: Bar Graph Grand Totals - show just Total (Text) for the Grand Total instead of the Bar

But I would say that it's not better even if you could disable that bar chart for grand total. Maybe if you just create sheet selector which changes view if only one value is selected

• ###### 10. Re: Bar Graph Grand Totals - show just Total (Text) for the Grand Total instead of the Bar

I can't think of any other workaround for this situation other than to use separate worksheets as Joe suggested. The problem is that once you've filtered so a single Department, the detail calculation and grand total calculation work exactly the same and there's no way to distinguish between them to end up with different results.

Jonathan

• ###### 11. Re: Bar Graph Grand Totals - show just Total (Text) for the Grand Total instead of the Bar

Thanks you, It is great solution.

When download the table to excel (crosstab to excel), im getting duplicated column - one with all the values inculde the grand, the other is with grand 0,

Is there any way to download to excel and see only one column with the relevant data including the grand total?

Thanks,

Irit