Yes, in this case it could be the issue in Axis value. Try to make Table only with Raw attributes and the measure during the date. It should give you the result. The formulas are perfectly OK.
Really, Concepte FAC it's not a calculated column, it's a field in the table. The Table1 is the result to Append two tables (TableA and TableB) with this fields:
TableA (Date, CodArea, Col, Cost)
TableB (Date, CodArea, Col, Concepte, Fact, ConcepteFac) where Concepte Fac it's a calculated column: IF(Concepte<>"", Concepte, Col)
The result Table1 it's (Date, CodArea, Col, Concepte, Cost, Fact, Concepte Fac). I try to change the calculated column by the concatenate formula and I explain how it has gone.
Your exemple it's awesome , thanks a lot. This is exactly what I want and the two matrix tables present the correct results.
But, I changed the conditional column by the calculated column concatenating the two fields as @Floriankx commented and the result, in my case, is still incorrect. It's the same as I had with the conditional column and I can not show the totals by Area in the whole column.
A difference between your Table1 or Merge1 origin table and my table are that the values of the rows for the Cost and Fact columns are null intead of blank that your exemple.
Could this be the problem? Thank you.
This is the data for the table:
Thank you very much in advance!
I've reduced tha data model to a unic table from previus Excel file and the result it's the same: