1 Reply Latest reply on May 7, 2018 5:44 PM by Zhouyi Zhang

    Sum & percentage


      Hi All,

      I'm having hard time in finding a solution on how to implement the below logic with Tableau and was hoping that some one will help me on this request.

      Here is my scenario -



      I'm having the data from Row 1 to 8 and I can calculate the total and % based on these rows. I need to do a calculation to derive the values for LP+SM+SS+NA, SM+SS+NA & SS+NA based on the respective rows in the data set and calculate the % based on the total of each type.  I want to achieve the below layout with the help of a single data set.


      Thanks In advance.