6 Replies Latest reply on Jun 19, 2017 10:03 PM by Akhilesh Singh

# Exclude

Hi Team,

i have a situation where i do have years dimensions under that i do have 5 members and i want to do grand total on that members excluding one member in the grand total calculation.

Ex : Years -2001,2002,2003,2004,2005

20      15      16    17     18

Grand Total : 15+16+17+18

But i want to display all that in years in the chart including 2001 (But in the grand total calculation i want to exclude the year 2001 value 20)

• ###### 1. Re: Exclude

Hello,

create a calculated field Total= Sum(IIF(Year=2001,NULL,Value)) and use this as updated values.

Create two separate sheets for actual values and other one is for total and then combine both into a single dashboard like below. I have attached the workbook also.

AK

• ###### 2. Re: Exclude

Hello Akhilesh i am taking the total from the tableau option it self.How can i do it.

• ###### 3. Re: Exclude

As, Grand Total feature will always total the sum of view. So, that's not possible. You have to use two different sheets to achieve this.

• ###### 4. Re: Exclude

So by using two charts how can i achieve it Akhilesh.Please let me know Thanks in advance.

• ###### 5. Re: Exclude

1) create one sheet with year in column shelf and values in Row.

2) create one calculated field Total= Sum(IIF(Year=2001,NULL,Value))

3) On new sheet, Put measure names from dimension self to column and measure value from measures shelf to text.

4) Put measures name to filter shelf and select only Total.

5) hide title of both the sheets by right click on title.

6) drag text for title on new dashboard sheet.

7) Keep both sheet on a single dashboard sheet.

8) Now you can arrange the width and height of rows and column as you want.

I can't help you with workbook file as I am not around.

AK

• ###### 6. Re: Exclude

Hello Rocky,

I have attached the sample workbook also. I hope this could help you better.

AK