Remove "blanks" from pivot table calculations

[NS2192]

I am trying to calculate frequency percentages for % of employees terminated per year by department, but the blank cells for employees who have not been terminated are ruining the final percentages. Is there a way to exclude these from calculations?

Thank you in advance.

[dflak]

We'd have to see how the data is organized and what your expectations are.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Stormin']

Usually you'd have something like a column [Terminated] with a value of 1 for terminated and 0 for current.
Sum the [Terminated] column to get the terminated count, divide by total.