Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
you can define a calculated dimension
if (category_of_sales<>'Processed'), category_of_sales)
or use set Analysis in Expression
{<category_of_sales-={'Processed'}>}