Incorrect total value showing

[Raul]

Hello,

I have this matrix visualization:

When I aply a filter from a field of a table (Servei) relationated with de Clients table that is relationated with the FactTable represented in this visualitzation, the total it show wrong (the Fact column is an amount column with the sum agreggation):

Why don't show the correct value (22,80) for the Fact column?

Thanks a lot!!

[Phil_Seamark]

Hi @Raul

Because the total line at the bottom is showing the total from line 1 for the X40 grp

[Raul]

But if I aply another filter from another table, the total is correct:

[Raul]

The relationships between the tables are that:

All relations with unic cross filter direction.

Any idea?

[Raul · Accepted solution]

I have found the solution: I have changed the cross filter direction between Serveis and Areas tables to Both and now the value of the column Fact it's correct. 

🙂