How to get the mentioned value in table ?

[suvechha_b]

Is it possible to ommit the line with yellow color.

How can I show in the table on category_of_sales='Unprocessed'.

category_of_sales is dimension.

[sunny_talwar · Accepted solution]

May be use a calculated dimension:

If(category_of_sales  = 'Unprocessed', category_of_sales)

and then check the 'Suppress When Value Is Null' on the dimension tab of the object properties

[Anonymous]

you can define a calculated dimension

if (category_of_sales<>'Processed'), category_of_sales)

or use set Analysis in Expression

{<category_of_sales-={'Processed'}>}