How to write calculated fields to evaluate variable row sums in Tableau?

0
votes

I had posted the question in Tableau community, but did not get a solution there for 20 days now. Hence posting it here (the Excel sheet containing the data as well as the desired output, and the Tableau workbook are attached in the post in the link):

https://community.tableau.com/thread/317048

Basically, how do I replicate Excel formulae like these in Tableau:

Output value in cell [i] = (Sum of some row(s) in all columns except in column[i] +/- Sum of some other row(s) in all columns except in column[i])/(Sum of some yet other row(s) in all columns except in column[i])

enter image description here

enter image description here

enter image description here

I am absolutely at the end of my wits, as I've never worked with Tableau before, but can't escape this task that has been dumped on me. So, any help is highly appreciated.

1
exceltableau-apicalculated-columnscalculated-field
Step one is to put a value in cell A1 – Alex Blakemore
@AlexBlakemore Ok, let's say I put 0 in there. What to do next? – Kristada673
Your data should have one header row listing field names, followed by a series of data rows, and no total row. So A1 should be the name of the field that has values A,B,C etc, let’s assume you call it Project. You’ll probably want to use Tableau’s pivot feature next to simplify your analysis, by making the data appear to have simply 3 fields: Project Level and Say Value. – Alex Blakemore
couldn't understand calculation you need? what should be the output of rows and columns in excel? in simple words? – Siva
@Siva Output value in cell [i] = (Sum of some row(s) in all columns except in column[i] +/- Sum of some other row(s) in all columns except in column[i])/(Sum of some yet other row(s) in all columns except in column[i]) Its actually better understood when you look at the attached excel sheet in the link. – Kristada673

1 Answers

1
votes

I posted a solution for X in your thread on Tableau's forums

You'll need to learn Tableau table calc well to build on this approach - unfortunately nested table calcs are one of the more complicated topics to learn in Tableau (but also very useful). So expect it take a little time to learn that topic well.