Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I wanted to display only those records in which recentitem=1. How can i do that using set analysis.
sum({<recentitem={1}>} MRP)
I want to display on those items with their MRP where recentitem=1
I believe dragonauta's suggestion should work
=sum( {$<recentitem= {1}>} MRP )
This will only show the sum of MRP for records with recentitem=1
I think dsjain has defined recentitem as sum(recentitem); there is a sum-line above.
On the Presentation sheet, there's a Suppress Zero-Values. Mark that, and the records with recentitem=0 will not show.
This is what i have defined in the expression.
This is what i have defined in the expression.
column 1
=sum({$<recentitem={1}>} MRP)
column 2
MRP
and by the way Suppress Zero-Values has been already marked. Let me know is whether there is anyother solution for this.
This should work:
Column1
recentitem
Column 2
Sum({$<recentitem={1}>}MRP)
Supress zero values must be checked
It seems you don't actually want to sum value s- in this case select "No totals" in the Total mode (expressions tab) of the sdtraight table.
And why have Resentitem as a expression. Use it as a Dimension. Then you dont have to worry about totals.