1 of 1 people found this helpful
Have your tried
right click the sum(sales) pill in my case and select format - then on format go tot the bottom entry and Type in what ever you want for a null value
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.
Thanks for your reply, Jim, but still not working.
The value that doesn't exist in the data source is the *** for that category, not the measure like in your case.
Ok did not realize that - Have you tried using and ifnull function like Ifnull([***],"Not Data") the function returns the first argument if the the argument is NOT null and the second if it is
Already tried that. It didn't work.
Deepak, already try those solutions, but no one did work for me.
3 of 3 people found this helpful
If someone knows another way to do this, I'd love to learn it, too.
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:
Hope this helps!
Great Work Jennifer!!!
It would be great if I could solve this only with Tableau, but your solution works pretty well.
Thank you, Jennifer!
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.