CODEWITHSUNDEEP
tableau-apicalculated-field
Manikandan S
Manikandan S

Reputation: 922

Is it possible to add custom calculated row in table?

My data source is Excel file. I imported the Excel file in a tableau. I want to create custom calculated row field for each column.

enter image description here

In the above picture, I can generate Grand Total in tableau from here Analysis -> Totals -> Show column grand totals. My problem is I want to generate another row which will have value from sum of High + medium row values.

Note: I taken this screenshot from excel sheet and please ignore the values in the row.

Upvotes: 0

Views: 1443

Answers (1)

Bernardo
Bernardo

Reputation: 3348

You can create a calculated field to sum just the High and Low values. Something like:

sum(If [Priority] = 'High' or [Priority] = 'Low' then [Value] end)

Upvotes: 1

Related Questions