Display row(s) with Quantity equal to cero

#1

Hello Dundas community. I have a table with 2 measures. I would like to display in this table only rows with “Invoiced Quantity in Kg” equal to cero. In this example I would like to display only the line in yellow.
Thanks,

tablewithKg
tablewithKg.png1098×470 53.5 KB

#2

Please, how could I do that?

#3

Hello,

You can filter out the not-required values by clicking on the funnel icon in the field Invoiced Quantity in Kg (under MEASURES in Data Analysis Panel) and set 0 for both FROM and TO values under ‘Filter’. You can also refer to this article: https://www.dundas.com/support/learning/documentation/analyze-data/metric-set-analysis-tools#h4-sorting-and-filtering

3 Likes
#4

Thank you so much Upasana, that’s just what I was looking for!