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.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]Name[/TD]
[TD="align: center"]Home Owner[/TD]
[TD="align: center"]Renter[/TD]
[TD="align: center"]Grand Total[/TD]
[/TR]
[TR]
[TD]Smith, David[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Stevens, Michael[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Terri, Michelle[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Young, Jessica[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]Name[/TD]
[TD="align: center"]Home Owner[/TD]
[TD="align: center"]Renter[/TD]
[TD="align: center"]Grand Total[/TD]
[/TR]
[TR]
[TD]Smith, David[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Stevens, Michael[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Terri, Michelle[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Young, Jessica[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]
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!