Rip1971
Board Regular
- Joined
- Nov 3, 2020
- Messages
- 65
- Office Version
- 365
- Platform
- Windows
Hi All,
i am not sure how to describe my problem so bare with me please.
i have worksheet that is used to provide data in a Pivot.
i the data is a column overdue which tell if a training has to be taken. however this training may be added multiple times to a user and therefor can be overdue multiple times. in the pivot is counted as multiple overdues.
i would like to make a report form the pivot table based on unique overdues.
I only see that they are not all unique when i open a detailed overview of overdues in pivottable
i am not sure how to describe my problem so bare with me please.
i have worksheet that is used to provide data in a Pivot.
i the data is a column overdue which tell if a training has to be taken. however this training may be added multiple times to a user and therefor can be overdue multiple times. in the pivot is counted as multiple overdues.
i would like to make a report form the pivot table based on unique overdues.
I only see that they are not all unique when i open a detailed overview of overdues in pivottable
Rapport_Dec.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Priority | (All) | ||||
2 | Overdue | Y | ||||
3 | Required | (All) | ||||
4 | Delivery Method | (All) | ||||
5 | ||||||
6 | User ID | Last Name | First Name | Count of Overdue | ||
7 | ND02987 | 2 | ||||
8 | ND39402 | 13 | ||||
Blanco_PivotTable |