4 Replies Latest reply on Feb 11, 2019 7:34 AM by Joe Oppelt

# clear a diagonal cell value

Hi - I am a newbie to tableau.  In the example below I would like to clear the diagonal cells where the cat 1 and cat 2 overlap.

Any help is appreciated!! thanks!!

• ###### 1. Re: clear a diagonal cell value

first welcome to tableau and the forum  please see the link Getting Started in the Forums

it will outline how to get the most out of the forum - - one sure way is to always include your twbx workbook so we can see what you are doing - the data sources and the data

you can try adding a filter   [cat 1]<> [Cat 2]

it may work but that depends on the data structure

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 2. Re: clear a diagonal cell value

So much depends on what those marks are made with.

If they are SUM([something]), you could create a calc like this:

IF ATTR([Cat 1]) <> ATTR([Cat 2]) THEN SUM([Something]) END

Where they are equal, tableau will default the calc to null.

Display that calc in place of SUM([Something]) where you currently have it.

• ###### 3. Re: clear a diagonal cell value

Hi Joe - this worked perfect but I see a problem based on what I have.

I have a grand total column which is actually maximum value of the row values. with setting the diagonal values to missing, the grand total no longer calculates, I am seeing all missing. Any suggestions?

the value is a sum(value).

grand total is set  as maximum value of row values

• ###### 4. Re: clear a diagonal cell value

At this point I need to see an actual workbook.  I made my suggestion based on what I imagined things were.  I made a good guess.  Now there are too many factors to guess at.  I need to work with something concrete.