12 Replies Latest reply on May 3, 2018 12:01 PM by Joe Oppelt

Grand Total with Multi Selection

I have created the Dashboard for Grand Total, i am having the issues as below,

When I select the multiple option grand total display is good and user likes this option as shown below,

But When I select only one option grand total is displaying along with the totals, user is not interested in this option as shown below,

Can anyone please explain how to avoid the grand total option when we select only option?

• 1. Re: Grand Total with Multi Selection

If you have grand totals turned on,. you're going to get the grand total.

I would make 2 sheets and do sheet swapping on a dashboard. You can make an LOD to count how many segments were returned.  If only one, display the sheet without Grand Totals turned on.  If more than one, display the other.

• 2. Re: Grand Total with Multi Selection

Can you please share one example as twbx.

• 3. Re: Grand Total with Multi Selection

Provide a sample workbook.

• 4. Re: Grand Total with Multi Selection

Please find the attached sample workbook

• 5. Re: Grand Total with Multi Selection

In the attached I made a copy of Sheet 1.  I made a filter (see Calculation1) that us an LOD calc to count how many segments are being returned to the sheet.

(Note:  I did "Apply to worksheets" on the Segments filter so that the same filter applies to both Sheet 1 and Sheet 1(2).)

(Another note:  I displayed Calculation1 in the title of Sheet1(2) so that I could make sure it was working properly.  The LOD calc essentially does EXCLUDE on all the dimensions on the sheet (in this case there is only one, but if you were doing this on a sheet with multiple dimensions, you would list all those dimensions in the list of fields to EXCLUDE.  Then it just does a COUNTD([Segment]) and that gives me the number of segments returned to the sheet.)

On Sheet 1 I set the filter to anything greater than 1.  On sheet 1(2) I set it to one.

Now Sheet 1 will display if there at least 2 segments.  And sheet 1(2) will display only if there is one segment.

So that takes care of the LOD and using it as a filter for swapping.

On your dashboard I floated everything.  I added a container, and I dragged Sheet 1 and sheet 1(2) into the container.  Because only one of these will display at a time, they will occupy the same space on the dashboard.  (This is called sheet swapping.)  To do successful sheet swapping, you have to do HIDE on the title of the sheets that you are swapping.  So at the top of the container I added a text box for a title.  You can do whatever you need with that.

My modified workbook is attached.  Your workbook opened with Tableau 2018 Beta without upgrading, so I assume that's the version you are using.  If not, let me know what version you need.

Hi JOE OPPELT,

I am also facing the similer issue , and unbale to open this work book as I am using tableau 10.2.

I would appriciate if you explain , the calculation and how to swap worksheets on dashboard .

though I tried to get the idea whatever you have writen , but stiil unable to solve it.

• 7. Re: Grand Total with Multi Selection

Saved as 10.2.  Attached.

• 8. Re: Grand Total with Multi Selection

I am trying to access your file but i am getting the error like,

The load was not able to complete successfully even after upgrading the newer version like tableau 2018.1

• 9. Re: Grand Total with Multi Selection

Can you open the 10.2 version I uploaded?

1 of 1 people found this helpful
• 10. Re: Grand Total with Multi Selection

It was a very quick reply . I followed your approch and It is really helpful to me.

BIG thanks JOE

• 11. Re: Grand Total with Multi Selection

Yes, It's working and thank you Joe.

• 12. Re: Grand Total with Multi Selection

Turns out I have 2018.2, not 2018.1, so that's why you couldn't open it.

Also I find that in 2018.2, tableau is no longer telling me that I'm opening an older version workbook and that it will get upgraded to 2018.2.

Anyway, glad I could get a working example to you.