I have attached dataset ( Sample 1).
I have to add two Percentage columns at the end of this Table
Non producing percentage = ( Non Producing / Total Dlrs ) * 100
Not enrolled percentage = ( Not enrolled / Total Dlrs ) * 100
When I am adding these columns percenatge is getting calculated for the entire table rather than each individual row.
Attached the Excel on the expected output ( Sample 2)
Thank you for the support.
I think this is the same question as here:
One other comment is that it might be better to calculate the percentage without *100 and then use Tableau's formatting to show this as a percentage. ...