Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot chart expression is not working?

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.

2 Replies
Not applicable
Author

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

Anonymous
Not applicable
Author

you  can share your   app please.