Calculated field in Pivot Table

Hello!...

How can I calculate the percentage of bags read using the two existing values and adding a new column to the pivot table: Count of Bags, summarize value field by Count, and Count of Check Bags, summarize value field by Count of Numbers.

Thank you for the help...

This could be done using Power Pivot which is a free add-in from Microsoft.
Select a cell in the table and then select 'Add to Data Model' on the Power Pivot tab.
Once the data is loaded to the data model select one of the cells below the solid gray line and paste the following into the formula bar: % Bags Read:=COUNT([Check Bags])/COUNTA([Bags])
Select Format and change from general to percentage.
Select Pivot Table > pivot table putting the three fields in the Values area.
Let us know if you have any questions.

When you say "verifies the respective condition" I feel as if you mean returns TRUE or FALSE. If you preform a mathematical function, such as =your formula + 0, on that formula it will return 1 or zero, which in turn can be counted.
To provide more specific help I feel that we would need to see a file that shows the verifying formula.
Let us know if you have any questions.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.