←Back to all posts
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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")

submitted by /u/NierraSol
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article→

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#AI formula generation techniques
#Excel compatibility
#rows.com
#real-time data collaboration
#formula generator
#Excel alternatives
#big data management in spreadsheets
#machine learning in spreadsheet applications
#conversational data analysis
#intelligent data visualization
#real-time collaboration
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions