Pivot Calculated Field doesnt help

[yeetboygenius]

I have a pivot table with my capex and opex hours in the columns with the names of project managers in the rows. the Capex and Opex hours are also summed into a column for a monthly total(see pic).

What I need is an extra column at the end of each month that shows the capitalization rate which is just CAPEX/MONTHLY TOTAL in % however I can not figure out at all how to do this. none of the %Of options work to do this what is wrong?

Any help is appreciated

EDIT: I understand a sample worksheet would help but it would take an immense amount of time to create one with non sensitive info that would help so the pic is all I can provide.

[yeetboygenius]

Actually here is a very compressed example of what I'm trying to add Capitalization rate to

[dflak]

"I get by with the help of my friends." In this case, a helper column. Quite often pivot table issues can be solved with the addition of a helper column to the source data.

In this case, C - Hours that determines how many hours on a row of data are Capex (it's either all or nothing) =IF([@Type]="Capex",[@Hours],0)

Then you can use this in a calculated formula: = C - Hours / Hours to get the ration. It's a bit funky in that type capex will always be 100% and type not-capex will always be zero, but the total column will be the ratio you want. I cant figure out a way to hide Sum of C-Rate in columns M & N. The data are correct, it's just that it doesn't tell us anything we don't already know. It doesn't look quite as bad if you move Type from columns to rows.