Hi, I'm hoping someone may be able to help out. I posted on an old discussion but haven't had any responses, so hopefully starting a new one may get a nibble. This was the previous discussion: http://community.tableau.com/message/172537#172537
If anyone can assist, it would be greatly appreaciated.
Thanks in advance,
Erin
The basic issue is that there doesn't seem to be any data for those combinations of dimensions you are using, and Tableau doesn't make up data when there isn't any. "No data" is different from Null, and that's why the ISNULL() function is failing.
However, we can tell Tableau to generate a null when there isn't any data, and that's using the following table calculation: LOOKUP(SUM([Flag]),0).
This table calc returns SUM([Flag]) for the current row, and Null when no value is found. Then you can wrap that in the IIF(ISNULL()) operation to return 0 or a value. alternatively, you could just do the lookup and then Format the calculation to set 0 to be the Text for Special Values.
Workbook is attached.
Jonathan
