data not extracted correctly

[theboss-123]

Hello ,

please shouldbe informed that i have two table  as below i linked the two table using default jointure on "Day" Column

First Table :

Second Table :

when i extract data using filter on 14/04/2022 and Spain it diplay corrcetly TR and NR but from first table it display Futs 12 of morocco

[Or]

I think you answered your own question:

"i linked the two table using default jointure on "Day" Column"

If the tables are only linked by day and not linked by country, then the correct total for 14/04 is 12. If you want the countries to also be linked, you should link that field as well.

[theboss-123]

when i linked the two fild Day and country i got no result

[Or]

Nothing is the correct result for 14/04 when picking Spain, as there are no lines associated with that set of values in the first table?

[theboss-123]

normally it must return column Void of Futs from first table

[Or]

I'm sorry, I don't understand what "Column void" means, or why you'd expect to get any sort of result when you filter for a combination which doesn't exist in the table...

[theboss-123]

this is the real result , i filter on Spain but it display Nbr de fus consommé of Maroc 

[theboss-123 · Accepted solution]

the issue soved thanks for your help