Hi folks

I have this table in tableau:

I need to aggregate the 'accepted' and 'not accepted' by the last 'fecha' iteration every 'procedimiento', but here is the catch: 'procedimiento' and 'fecha' are non-visual elements in the worksheet where these calculations need to appear.

That means a sum of 2 accepted and 1 not accepted.

I tried a calc field like this:

I put 'Procedimiento' and 'Fecha' on the Marks shelf, made 'Sum of Accepted' compute by 'Fecha' and moved 'Sum of Accepted' to the filter shelf indicating 'non null values'.

Problem is I get values of '1 1' instead of value '2' for my 'Sum of Accepted' in my worksheet, like this:

Here is my tableau public workbook Workbook: calc by last date of a dimension field

Thxs for any help

Jimmy