Hopefully this is easy, but I would like to format 0's in my pivot table as '-', so that they match with the null value fields. In Excel you could do it with a formula like this: #,##0;-#,##0;-
May be do like this
If(Expression = 0, Null(), Expression)
Thanks Sunny, that worked perfectly!
It would be great if there were additional formatting options so that 0 could be formatted separately, as in Excel.
Maybe use an If:
If ( YourExpression = 0 , null() , YourExpression )
Then it actually will be Null().
Retrieving data ...