Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)