Pivot Table Modifications

Hello Excel experts

I am a little new to using excel Pivot tables, so my requirement may not be very tough for some of you, and I may sound too naive to ask, but request you to help me with this please.

I need to create a Pivot which looks like the table in the "Requirement" tab of the attached excel sheet.

I managed to add my Pivot table in the "Data and Pivot" tab, but I am struck at the below steps - request you to help.

1) Adding "% pending" column as an additional column
2) Remove the Top row in the Pivot table which has "Count of Lean & Tested" and "Lean Train & Tested"
3) Conditional formatting in last column as red for all values > 0%

I would prefer to learn how it is to be done, instead of having them done by others. Please help !

The second and third points can be managed in manual editing as well. The first point is what I am looking for some help with.

Note that I tried "Calculated Field" option, but since the "Completed" and "Pending" columns in the Pivot are not the actual columns themselves but are column cell values represented as columns, I am not able to add the "% Pending" column as "Calculated Field"

I am able to "Show Value as" "% Row Total" But I need this percentage only for the % pending column and not all columns along with the "Pending" column which has value as well.