<div>
Can you upload that sample as an Excel file rather than screenshot?
</div>


<div>
Here is a sample of the pivot table I wam working with. &nbsp;I had to remove a lot of the data as it is PHI so if I missed something I am sorry. &nbsp;It should be OK. &nbsp;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.<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268378/pivot_table_example.xlsx" target="_blank" class="file-inline" title="Example of the data I am using. (89 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>pivot_table_example.xlsx</a>
</div>


pivot_table_example.xlsx

<div>
WOW it was that dimple. &nbsp;I was looking at doing some advanced filtering. &nbsp;Trying to figure out how I could use the pivot table functions. &nbsp;Glad to see it was something simple.<br />
<br />
Thanks again.
</div>


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


<div>
<div class="content wysiwyg-content">
Using DCount on a pivot table. &nbsp;<br />
<br />
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. &nbsp;I have a filter on the pivot so it is a dynamic range that I am working with , &nbsp;The summary section I have is seperate from the pivot table. &nbsp;<br />
<br />
Attached is a screen shot of the what I am looking for. &nbsp;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. &nbsp;I did name my pivot table MSO_CASES.<br />
<br />
I am using Excel 2007<br />
<br />
Thanks,<br />
Rodger<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w05/1268315/pivot_table_example.JPG" target="_blank" class="file-inline" title="pivot_table_example.JPG (91 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>pivot_table_example.JPG</a>
</div>
</div>


pivot_table_example.JPG

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 Summary Help

Pivot Tables

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.