Doghouse308
New Member
- Joined
- May 28, 2019
- Messages
- 13
I have a pivot table that is tracking occurrence per device as follows:
<colgroup><col><col></colgroup><tbody>
</tbody>
I need to find a way to count the number of instances with 2 and with 3 or more occurrences per device. I tried using GETPIVOTDATA, but cannot find a way to count conditionally. I also tried using the GETPIVOTDATA inside of a countif without success.
I greatly appreciate any suggestions. Once I have this one last piece of the puzzle I can complete a dashboard project.
PJ1065 | 1 |
PJ1089 | 1 |
PJ1156 | 1 |
PJ1197 | 1 |
PJ1573 | 2 |
PJ1754 | 1 |
PJ3159 | 1 |
PJ3223 | 3 |
PJ3648 | 1 |
PJ3944 | 1 |
PJ4064 | 1 |
PJ4073 | 1 |
PJ4309 | 1 |
<colgroup><col><col></colgroup><tbody>
</tbody>
I need to find a way to count the number of instances with 2 and with 3 or more occurrences per device. I tried using GETPIVOTDATA, but cannot find a way to count conditionally. I also tried using the GETPIVOTDATA inside of a countif without success.
I greatly appreciate any suggestions. Once I have this one last piece of the puzzle I can complete a dashboard project.