Forum Discussion
Table to show blank values when using sum
Thanks for the reply,
For some reason this didn't yield the expected results,
I ended up doing a simple measure that solved the issue:
blank = sum(table[value])+0
Sorry, what is the "Sum of" column? is it a measure or a calculated column?
Also the option is "Show item with no data" - should be visible for ProjectName and not for the Measure in the visual.
Sum - when you have values you can choose to have sum, average, min, max etc. or "Don't summarize", and it's only when it is on "Don't summarize" I can select "Show item with no data".
It's not a measure, just a regular decimal number column.
Exactly, Why would you summarize the Project Name in your visual? Maybe I m missing something. Can you share what columns are you showing in the Matrix/Table?
If you do not summarize Project Name, then you can rightclick in the Fields visual and select "show item with no data".
I never said I wanted to sum the names, must be a missunderstanding, sorry if I was unclear somewhere.
Like I've said, if I don't select Sum I can see the "show item with no data", but I need to sum the values, and then the option disappears.
You can do it in three steps.
1) Select your table column where you have some numbers and blank values and click "Don't summarize"
2) Then you can select the same column again and activate additionl option "Show items with no data"
3) And then you can select "Sum" on the same column again and it will calculate SUM of the values and also keep the BLANK values.
