asked on

Pivot Table Summary Help

Using DCount on a pivot table.

I have a pivot table that is giving me just what I want to know, but now I need to make a small summary of how many rows I have and then how may rows to I have when the value in a column is over 1. I have a filter on the pivot so it is a dynamic range that I am working with , The summary section I have is seperate from the pivot table.

Attached is a screen shot of the what I am looking for. The rows with the check mark I have I am looking for the other two in the summary Number of Physicians 24 and Number of Physicians with MSO cases over 48 hours which is 17. I did name my pivot table MSO_CASES.

I am using Excel 2007

Thanks,
Rodger
pivot_table_example.JPG

Rob Henson

Can you upload that sample as an Excel file rather than screenshot?

Rodger Dill Jr

ASKER

Here is a sample of the pivot table I wam working with. I had to remove a lot of the data as it is PHI so if I missed something I am sorry. It should be OK. The dummy column is used when I need to do a calculation in pivot table I just did not include it in the example, but I hvae another field that calculate the percentage for each physician of how many cases were over 48 hours.
pivot_table_example.xlsx

ASKER CERTIFIED SOLUTION

Rob Henson

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Rodger Dill Jr

ASKER

WOW it was that dimple. I was looking at doing some advanced filtering. Trying to figure out how I could use the pivot table functions. Glad to see it was something simple.

Thanks again.

Rob Henson

I did wonder if there was a more complicated way but sometimes simpler the better.