KNOWLEDGE BASE

How to Calculate Percentage from the First Row


Published: 06 Jan 2022
Last Modified Date: 06 Jan 2022

Question

How to calculate percentage from the first row

eg
User-added image

User-added image

Environment

  • Tableau Desktop

Answer

1. Create a calculation field [Percentage from first row].
Formula: 
LOOKUP(SUM([Profit]),0)
/
LOOKUP(SUM([Profit]),FIRST())

2. Add  [Percentage from first row] to view.

3. Arrange the Tableau Calculation Direction by right click on  [Percentage from first row]  on text mark card >  click on [Edit Tableau Calculation] > select [Table(Down)].

※Please find sample workbook Percentage Sample.twbx - Sheet2 for more details




 
Did this article resolve the issue?