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