Pivot Calculated Field issue

Hi guys, Im still learning excel and im having a hard time inserting a formula in a pivot table that initially created in a manual table.

I wanted to to utilize the pivot function of opening a new sheet with the filtered values + the formulas that I want to show.

Here's a link to the sample data set that i'm using. Here's the breakdown:

• have 200 transactions over a 3 day period (no dates for this one sadly) with a sudden decline in approval rate
• divided it into 2 groups (first half, last half)
• Wanted to make a pivot table checking the approval rates of each of the following: Card type, Country, MID (merchant ID).
  • This is just to investigate the root cause.

• I already have a sample formula for the Card type part but having trouble inserting it in a pivot table. It should be easy to apply to other pivot tables once I get this one done

  =(COUNTIFS(Raw!H:H,"First 100",Raw!B:B,"Approved",Raw!D:D,"Amex")/COUNTIFS(Raw!H:H,"First 100",Raw!D:D,"Amex")