Expression Help

sona_sa — Mon, 17 Sep 2018 14:25:15 GMT

Hi,

I have to display according to selection on Transaction ID or Month, Transaction Amt in the straight table.

Transaction ID --> A007 has done the transaction in Oct but not in Nov, But I have to display in stratght Table

For A007 --> Oct Month -->Transaction Amt --> 205 and Nov Month -->Transaction Amt --> 0

In The straight table by Expression.

Please find the attached QVW for help.

Thanks

Re: Expression Help

vishsaggi — Mon, 17 Sep 2018 14:44:30 GMT

IN the presentation tab of your chart properties uncheck supress 0 values. It will show Nov as 0.