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

    Sum & percentage

    jagadeesh.kattamuri.2

      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.

       

      Regards,

      Jagadeesh.