count without movements

[spividori]

I need to have 2 tables:
1. Sum (CANT)> 0.
2. Sum (CANT) = 0.
and that when selecting a DATE, it shows the corresponding results in each table.
I need to do it with formulas in the tables, not in the script. These are summary data. The actual base is big.

I attach an example.

Regards.

[QFabian]

Hi @spividori , please check the attached file,  i created two tables :

and for the 'CANT = 0' table, please check this part :

[sergio0592]

Hi,

Try as calculated dimension

=aggr(if(sum(CANT)>0,ID),ID)

and check "Supress when value is null" 

[spividori]

Hi.

Thanks for replying, but it doesn't work.
In the image I show that when selecting 08/17/2020 this takes 5 records, these records appear in the table of movements, but I need to separate their do not.
I forgot that I also need to filter them by ACTIVE = S.

I attach excel files with the data I am working on.

Regards.

[spividori]

Any idea?.

Regards.