Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Pivot chart expression not showing values when it is in chart but the same expression is showing values when I add into text object
below are the details in chart
dim1: ID
dim2: Log
dim3: CB
dom4: Status
expr1: Sum(Amount)
expr2: Sum(CancelledAmount)
expr3: Sum(Amount)-Sum(CancelledAmount)
expr2 is not showing values. please can anyone suggest me is there any thing wrong in expression value?
Thanks.
Hi, do you have null value or zero if cancelledAmount is zero for any one of dimension values.
Chart Properties --> Presentation --> check "Show Zero Values" & "Null Value=0" & Missing value=0
you can share your app please.