I had difficulty generating the grand total of a consolidated expense information, I will relate the case more detail so that you can help me analyze what may be the cause.
I have created the following calculated field:
IF ISNULL (SUM([Hoja1 (ConsolGast)].[Realcop]))
This calculation if it finds null value brings the value from the realcop field. On the contrary, it performs the operation
Use the result of calculated field (Saldo_Cop) and divides it by the data provided in the "tasaCambio" source. There he performs the conversion of pesos to USD per month. The problem is that he performs the calculation by columns but not by rows. I could analyze that generates field-level calculations either columns, rows but do not realize it.
Have you seen this Tabelau Community Forums document on totals in Tableau: Why Your Grand Total or Subtotal Isn't Working as Expected
This is an excellent resource for gainig an understanding of what is occurring with the view.
Hope this helps!