Properties>Dimension>"Show All Values" is not working

[Anonymous]

Hi All,

I have two fields, say

Table1: Field1,Name with values A,B,C,D

Table2: Field1,Date,Amount (Transactional Data Table but having values only for A,B,and C and it will never have values for D)

I am now making a Straight Table Chart with Dimension Field1 and Expression as if(Field1<>'D',Sum(Amount),some sum formula for D's value). But the problem is it's not showing value for D because there is no value for D in Table2. "Show All Values" is also not working.

Note:Formula above is written in narrative form for simplicity.

Please advise.

Thanks and BR,

SAK

[Anil_Babu_Samineni]

Try, From Presentation Tab - Uncheck the Suppress Null Value (If sure you are working on Straight Object) or else go to + symbol might be You will get inside options called Show value just give 1(If not Straight / pivot object)

[Anonymous]

It's straight table and "Suppress null value" is unchecked.

[Anil_Babu_Samineni]

Shoaib, Can you please share your Application