Hide rows with no values

Question & Answer
, , , ,
1

I have the following dashboard (table)

image
image743×337 32.7 KB

YearMonth and Merchant ID are dimension columns
“Type 1 Fraud” and “Type 1 Sales” are columns that apply some filters on the dataset to filter out rows that have particular properties.
Last column is “Type 1 Fraud” divided “Type 1 Sales” to show fraud to sales ratio.

Is there a way to hide rows in the table that have no values in all corresponding cells? (highlighted by a red line)

2

Hi @impala67,

what about a filter?

grafik

Maybe you have to combine the 2 columns in a caulculated field and check if both are 0/null and filter on that field.

BR