Generate 0 when there is no Sales

[#1]

Hi Experts

I have a Sales Straight Table

dimensions are

Branch

Branch Name

Sales Manager

Expressions are

Monthly Targets against Sales Manager

Sales

Now some branch don't have sales at the first week of the month,

so instead of their Sales values showing as Zero, the entire line is not showing up in the table

i tried un checking suppress  when the value is null, check show all values  in dimensions tab

i tried  un checking suppress Zero  values , 0 in null symbol and missing symbol

Any other Ideas to generate Zero for branches with No Sales

Please Suggest

[m_woolf]

Generating Missing Data In QlikView