How do I get zeros to show as dashes like accounting formatting in excel?
I am not aware of how kind of formatting, maybe using the FORMAT function?
Proud to be a Datanaut!
You could add a calculated column.
IF ( Table1[Column1] = 0, "-", Table1[Column1] & "" )
This converts the numbers to text and then I am unable to sum.