Restrict data based on the field value in staright chart

[Anonymous]

Hello All,

I need some help in finding a way to restrict data based on value in a field, I have a field quantity, I wanted to show the data in the straight table object where quantity > 0. Any help is highly appreciated. I tried creating an expression like

=sum({$<[Item Quantity] ={>0}>}[Item Quantity]) ,but it did not work.

Thanks

Heera

[maxgro]

field name? case?

[sasiparupudi1]

May be you need to round [Item Quantity] to 0.

try round ([Item Quantity],0)

[Anonymous]

Kush,

I am attaching an example here. In the attached file I don't want to see  record C in my resultant set as it as quantity =0. Please suggest me if there is way I filter it out at the dimension level.

Thanks

Heera

[maxgro]

see attachment

[#6]

sum({$<[Item Quantity] =e({0})>}[Item Quantity])try this

Thanks

Sai