Instead of "-" I want "0" in my Pivot Table

[BhaminiParmar12]

I have a Pivot Table in that table Row I have category in Column we have Sub Category and in Values I have Sales in my pivot table wherever there is "-" I want "0" in Qliksense

[Kushal_Chawda]

@BhaminiParmar12 what is the measure ?

[BhaminiParmar12]

Hi @Kushal_Chawda  Measure is Sales
Below is my Script 

LOAD
Category,
Sales,
Profit,
"Sub-Category"
FROM [lib://Bhamini:DataFiles/ Task - instead 0.xlsx]
(ooxml, embedded labels, table is Sheet1);

[BhaminiParmar12]

@Kushal_Chawda as you can see in my Pivot Table There is "-" But I want 0 
where ever there is  "-"

[Kushal_Chawda]

@BhaminiParmar12  It's because you don't have sales for all combination of Category and Sub Category, you need to generate and add missing combination of Category and Sub category to convert NULL to 0. See the attached