Help with First Sorted Value + AGGR

[antoniodneto]

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!

[anurag644]

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"