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?
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.
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:
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?
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?
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.
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.
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
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.
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?