←Back to Beyond Market Intelligence
•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Sum unique values in Pivot Table without Data Model

Our take

If you're managing surgical case data in a spreadsheet and want to accurately summarize doctor performance using pivot tables, you may face challenges, particularly when tracking unique instances of surgeries performed. Specifically, if your spreadsheet setup only counts cases where a doctor is assigned as the first case of the day, you might struggle to capture accurate metrics for days when multiple doctors are present. Fortunately, there are alternative methods to calculate unique values without relying on the Data Model feature, even on Mac.

I have a spreadsheet that tracks the surgical cases our practice sees. In this spreadsheet, each case is its own row. Column A is the date. Column B is the primary doctor assigned to the case. Column C lists which doctors are present at the practice that day (ex: "Dr.X" or ""Dr.Y" or "Dr.X/Dr.Y"). The first case of the day gets a "1" in Column D.

I am trying to use pivot tables to create a summary of some metrics for the surgeries. Part of the stats we look at are how many surgeries a doctor performed when there are two working that day vs just one.

The issue I'm running into is when I try to run statistics by the month, filtered by Column B and Column C, I cannot get an accurate count of the number of days a doctor worked that month. If I want to run stats for Dr.X on days both doctors worked, Column D only gets added if Dr.X was assigned to the first case of that day.

I know that you can add unique values by using the Data Model feature, but this isn't available on Mac. Is there any other way I can calculate this?

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

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#spreadsheet API integration#big data management in spreadsheets#conversational data analysis#rows.com#real-time data collaboration#intelligent data visualization#data visualization tools