Hi,
Please see example below. I want to use a Pivot table to filter data to show just the studies that contain patients from the 'South' area, is this possible?
As per example below I want to be able to see all the patients in all areas but only for studies that have patients from the south. Please see example below - hopefully that makes my requirements a bit easier to understand . I put together an array formula that works well for small tables but is too much with one one my sheets that contains 200,000 rows.
Cheers in advance
Before filtering:
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
After filtering:
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
Please see example below. I want to use a Pivot table to filter data to show just the studies that contain patients from the 'South' area, is this possible?
As per example below I want to be able to see all the patients in all areas but only for studies that have patients from the south. Please see example below - hopefully that makes my requirements a bit easier to understand . I put together an array formula that works well for small tables but is too much with one one my sheets that contains 200,000 rows.
Cheers in advance
Before filtering:
Study ID | Study Short Title | Study Patient ID | Area |
1346 | LLP | 90126 | Northwest |
1346 | LLP | 91749 | Southwest |
1346 | LLP | 92554 | Southeast |
2346 | PLP | 92569 | South |
2346 | PLP | 92803 | Northwest |
2346 | PLP | 92821 | East |
3346 | RLP | 92825 | West |
3346 | RLP | 92874 | South |
3346 | RLP | 92891 | Northwest |
4346 | TLP | 92909 | Southwest |
4346 | TLP | 93151 | PCRN-NW |
4346 | TLP | 91736 | SouthEast |
5346 | VLP | 91737 | Southwest |
5346 | VLP | 91738 | Bortheast |
5346 | VLP | 91767 | West |
6346 | XLP | 91783 | Northwest |
6346 | XLP | 91791 | South |
6346 | XLP | 91801 | East |
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>
After filtering:
Study ID | Study Short Title | Study Patient ID | Area |
2346 | PLP | 92569 | South |
2346 | PLP | 92803 | Northwest |
2346 | PLP | 92821 | East |
3346 | RLP | 92825 | West |
3346 | RLP | 92874 | South |
3346 | RLP | 92891 | Northwest |
6346 | XLP | 91783 | Northwest |
6346 | XLP | 91791 | South |
6346 | XLP | 91801 | East |
<colgroup><col span="3"><col></colgroup><tbody>
</tbody>