5 Replies Latest reply on Apr 19, 2016 3:42 PM by Derrick Austin

# Clear or white Off Particular Cell

Hi Experts,

I have a Worksheet with data which i should white off that particular cell or column but i should able to see sub total , I have like 12 measures and i am using table to show data because users wants table  to been shown. please see below screen shot.

If i change anything to one column it changes to all the 12  measures columns. I tried splitting all those measures individually.  Please see excel sheet

1) I divided positive and negative to show totals for each measure (Which Sum of positive and Sum of negatives for that measures)

2) measure 2 is the  basically a LIMIT(Like only constant number for that sub item and sub name ) 15,000 for some rows and null for sum rows .

So, users wants to see only 15,000 in the subtotals for different names and they don't want to see the 15,000 anywhere else  in the column but they need to see total ( Right now i am using MAX function to show the 15,000 in the total )

I want to remove that 15,000 from all rows and show only total. (cell formatting that to white color or blank or maybe 0 also works for me)

Any help would be good. I am posting first-time in tableau forum. Please reply to me with any ideas, if anybody did not understood the issue please let me know.

• ###### 1. Re: Clear or white Off Particular Cell

Hey Narasimharao,

Have you considered using a conditional color based on a calculated field?

Basically make a field like this and drag it to color,

IF [MyDimensionToWhite] = 'YesWhiteThisOne' THEN 'white' ELSE 'black' END

Hope this helps!

- Derrick

1 of 1 people found this helpful
• ###### 2. Re: Clear or white Off Particular Cell

Hi Derrick,

I Just tried it , First of all it is treating as Dimension , But i need measure. Secondly when i drag that to color shelf all other remaining measures color also changes. When i try to format any one measure it all applies to all other measures.

• ###### 3. Re: Clear or white Off Particular Cell

Without looking at your workbook, it is hard to say for sure - but it sounds like you are coloring based on something already, for example SUM([Sales]).

If this is the case - you could do something similar for the label portion.

IF [dontshowthis] = 'yes' THEN '' ELSE [myLabel] END

• ###### 4. Re: Clear or white Off Particular Cell

Hi,

I have attached the sample workbook, if you open the workbook, you will find an measure 2 column in that column, I don't want to show 15,000,000 and if you observe the total is wrong according to the requirement ( the total is correct according to tableau) , to correct the total i am using the max function which will fix issue of showing the correct sub-total for my requirement .

But i am not able to hide or blank out or white off that column values.

Thanks,

Narasimharao Thurai

• ###### 5. Re: Clear or white Off Particular Cell

Ah, I see. You won't be able to do that with Measure Values. You can't reference "Measure Values" in a calculated field like you can [Sales], for example.

Best case, you could break this up into multiple views and combine them on a dashboard - then use one of the options up^ to blank it out.