I have a list of about 1000 names that fall under 1 of 2 categories: Home Owner and Renter.
Approximately 100 or so people on this list fall into both categories.
Out of these 100 or so people, a number of them have multiple homes and multiple renters.
I have this data in my pivot table and I want to be able to display how many people fall under both categories and come up with a percentage from that.
So say, out of the given population, 11% of people are both home owners and renters.
<tbody>
</tbody>
I'd like to keep this data in a pivot table if possible, just because it easiest to navigate and auto-updates if information is added.
How can I filter this to show only fields that have at least 1 value in both columns?
I'm sure there's a simple way of doing this, but I can't seem to think of one right now!
Approximately 100 or so people on this list fall into both categories.
Out of these 100 or so people, a number of them have multiple homes and multiple renters.
I have this data in my pivot table and I want to be able to display how many people fall under both categories and come up with a percentage from that.
So say, out of the given population, 11% of people are both home owners and renters.
| Name | Home Owner | Renter | Grand Total |
| Smith, David | 0 | 2 | 2 |
| Stevens, Michael | 1 | 1 | 2 |
| Terri, Michelle | 2 | 0 | 2 |
| Young, Jessica | 1 | 2 | 3 |
<tbody>
</tbody>
I'd like to keep this data in a pivot table if possible, just because it easiest to navigate and auto-updates if information is added.
How can I filter this to show only fields that have at least 1 value in both columns?
I'm sure there's a simple way of doing this, but I can't seem to think of one right now!
