Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have this table below:
Codigo do registro | Identificacao da Loja | NSU Host da transacao | Data da transacao | Horario da transacao | Tipo de lancamento | Data de lancamento | Tipo do Produto | Meio de Captura | Valor Bruto |
CV | 33186327000159 | 200049753067 | 20191230 | 132509 | 0 | 20200129 | C | 3 | 5760 |
CV | 33186327000159 | 200049753067 | 20191230 | 132509 | 1 | 20200129 | C | 3 | 5760 |
On my field Tipo de lancamento I have 0 and 1.
I should use only the value 1 and exclude 0.
The field Tipo de lancamento can be 0,1,2 and 3. So when I have lines with 0 and any another I need always exclude 0.
Can you guys help me to build that?
Tks!
Hi Antonio,
Try if this works,
select the table on the right side, click on Add-ons and Unselect the "Include Zero Values"
and if you don't want to show the null values in the table which display as '-'
On the right side, select your dimension and unselect "Include Null values"