Calculated field in a pivot table

[dmfweb]

I stumped ChatGPT so I came here.... LOL

I have a pivot table with dates in the rows and a field called DSAT/CSAT in the column. (There are 2 possible values in CSAT and DSAT, yes the choices are CSAT and DSAT )
I need to do a formula on each line which would be csat divided by csat + dsat


Is this possible to create a column with the calculated formula?

 

[Armstrong_N14]

You would want the header of the RAW data table to be CSAT and DSAT and its values to be 1 and 0, By then, you can do the calculations.

 

[dmfweb]

You would want the header of the RAW data table to be CSAT and DSAT and its values to be 1 and 0, By then, you can do the calculations.

Thank you!