1 Reply Latest reply on Oct 18, 2018 9:04 AM by patrick.byrne.0

# Problems in obtaining results by grand total

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:

• Saldo_COP

IF  ISNULL (SUM([Hoja1 (ConsolGast)].[Realcop]))

THEN

SUM([Realcop])

ELSE

SUM([Realcop])+SUM([Hoja1 (ConsolGast)].[Realcop])

END

This calculation if it finds null value brings the value from the realcop field. On the contrary, it performs the operation

Total USD

[Saldo_Cop]/(ATTR([Tasa (TasaCambio)].[Tasa]))

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.

• ###### 1. Re: Problems in obtaining results by grand total

Hello Sebastian,

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!

Cheers,

Byrne, Patrick