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.
Can you union your data to itself? Does this mean single data set?