I'm trying to show the number of registers in my dataset by category and ***. The problem is that some of the categories doesn't have a single row of a certain ***, but this data still relevant for my client, so I want this data to be displayed as zero.

You can see here that the category 'J1234' for example doesn't show the 'M' data, cause it doesn't exist in the data source. How can I display this info?

The only way I know to do this is to create a combined dimension table with Category & Gender: this will have every possible combination of the two. Then create a Left Join between the Combined Dimension Table and your Data Table. Then use the Combined Dimension table columns in your view, and the Data measure in your view.

If your data is in a database, it's pretty easy to create a view that combines all your dimension values together. If it's in a view, you don't have to worry about data replication taking up space. If your data is in a spreadsheet, Macros or PowerPivot can make this manual task a little easier.

1. Combined Dimension & Data in 2 separate tables:

2. Connect from tableau and set up join:

3. Set up view. Use Columns from Cat.Gender, not from Data.

4. And here we can use Jim's trick (I just learned about this from you, thanks Jim!) to right-click on the Sum(Count) pill, choose Format, then put 0s in the null cells:

Yes, I have seen a few questions like this in the Forum, and keep hoping someone will reply with a way to handle this in Tableau only. It would be possible to use Custom SQL (I think) to create a Cartesian join and create a combined dimension on the fly while bringing data in, but from my experience with Tableau and what I have heard in training is that for performance considerations Custom SQL should be avoided.