Available solutions to replace " - " to 0 in pivot table

[ahmadov_10]

Hi Experts, any solutions to replace - by 0 in my pivot table (it's shown - because we didn't have result for the specific month)

PS :

rows : Category

columns : month-Year like : sept.2017

value : salesAmount

[Gabriel]

Hi,

In the script, I will try something like this

LOAD 

fld1,fld2......,

IF(ISNULL(salesAmount),0,salesAmount)    AS [salesAmount]

FROM [lib://QVD/DATA.qvd](qvd);

OR 

In the Chart try

ALT(SUM([salesAmount]),0)