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