4 Replies Latest reply on May 16, 2012 2:28 AM by Egor Larin

Grand total of calculated field

I have a problem.

I have 3 transactions A,B,C and i have 3 parametrs X,Y,Z and Total (default Column Grand Total)

Z=Y/X (but I made a calculation of this in the database (simple excel ^_^)

The picture shows Grand Total of X,Y is correct, but Z Grand Total isn't - it's sum of all transactions by Z in Column. True value of this total is

Total Y (182803) / Total X (519702) = Total Z (0.35 )

and I want to see this total in this.

How can i be?

Message was edited by: Larin Egor

• 1. Re: Grand total of calculated field

I recommend doing the Z=X/Y in Tableau instead of in data source. That way Tableau will know how to calculate the total for it. It can be easily done with a calculated field.

1 of 1 people found this helpful
• 2. Re: Grand total of calculated field

Sorry, but it does not work

I made an example of it in attach. Please take a look at it.

PS. I gave you the wrong information about my calculations

Z=Y/X

• 3. Re: Grand total of calculated field

Fixed.

The correct formula in Tableau is:

`Z = SUM([Y])/SUM([X])`

see attached