Pivot table does't show values of max(Date) until I go deeper in the table

[Diego_780]

Hi Qlik experts!

I have a Pivot table in which I would like to show the result of a Sum only when it's the max date, I do have the expression and it works fine:

= SUM({$<FECHA = {'$(=max(FECHA))'}>} INCIDENCIA)

Now, in this pivot table I want to show in columns first, the group which it belongs and then, two columns that show the max(date) and the sum of the INCIDENCIA, in rows I have the dimension that gets the value from INCIDENCIA. 

This display will show me the sum correctly but only if I go deeper in the table, meaning by using filters like this:

But if I take out any filter, it will show the value to 0%, in measurments I have Ult.Fec. = Max(Date) and Inc. = SUM({$<FECHA = {'$(=max(FECHA))'}>} INCIDENCIA).

If it doesn't have any filters it shows like this:

Can somebody explain why it does show the max(date), but I can't see the sum of the max(date) without the filters? All the values are in the same table except Date that has Date in the table and in another table that is a calendar but it shouldn't be a problem IMO, they are relationed only so I can use a calendar to play with the table.

Thanks.