CODEWITHSUNDEEP
databasetableau-apicalculated-columnscalculationroi
Jaime Hutchins
Jaime Hutchins

Reputation: 46

Tableau - Display last number in a window calculated list as a text label to be presented as a headlining number

I have a window calculated list in Tableau [img 1] that is the accumulation of savings and costs over months based on a number of parameters that calculates my ROI.

I want to take the last number in the column shown and use the value as a headline number on a dashboard [img 2] (would show 188% instead of -95.22%), however if I remove the per month separation, because its using a windows calculation for each month, the ROI figure is compounded, but the data is cumulative.

I need help to figure out if its possible to maintain this final number to show somehow in the dashboard.

enter image description here enter image description here

Upvotes: 0

Views: 154

Answers (1)

Kalidas
Kalidas

Reputation: 149

  1. Sort the rows in the order that you want.
  2. Create a calculated field that calls the index() function and place it on the filter shelf (with compute using set to table down).
  3. Adjust the filter settings to only retain the rows you want to show.

Upvotes: 2

Related Questions