I inserted a pivot table and the amounts do not total?
Investment | Ex-date | Pay date | Amount |
DNP | 12/29/2019 | 1/9/2020 | 0.07 |
HPF | 1/9/2020 | 1/30/2020 | 0.12 |
DNP | 1/29/2020 | 2/9/2020 | 0.07 |
HPF | 2/11/2020 | 2/27/2020 | 0.12 |
DNP | 2/26/2020 | 3/9/2020 | 0.07 |
VHT | 3/9/2020 | 3/12/2020 | 0.45 |
VPU | 3/9/2020 | 3/12/2020 | 0.87 |
HPF | 3/10/2020 | 3/30/2020 | 0.12 |
FRO | 3/11/2020 | 3/25/2020 | 0.40 |
FFIN | 3/12/2020 | 3/31/2020 | 0.12 |
FSK | 3/16/2020 | 4/1/2020 | 0.76 |
DNP | 3/29/2020 | 4/9/2020 | 0.07 |
HPF | 4/8/2020 | 4/29/2020 | 0.12 |
DNP | 4/28/2020 | 5/10/2020 | 0.07 |
HPF | 5/7/2020 | 5/28/2020 | 0.12 |
DNP | 5/27/2020 | 6/9/2020 | 0.07 |
FRO | 6/2/2020 | 6/21/2020 | 0.70 |
D | 6/3/2020 | 6/19/2020 | 0.94 |
HPF | 6/9/2020 | 6/29/2020 | 0.12 |
FFIN | 6/14/2020 | 6/30/2020 | 0.13 |
FSK | 6/15/2020 | 7/1/2020 | 0.60 |
VHT | 6/21/2020 | 6/24/2020 | 0.76 |
VPU | 6/21/2020 | 6/24/2020 | 1.26 |
DNP | 6/28/2020 | 7/9/2020 | 0.07 |
HPF | 7/9/2020 | 7/30/2020 | 0.12 |
DNP | 7/29/2020 | 8/9/2020 | 0.07 |
HPF | 8/11/2020 | 8/30/2020 | 0.12 |
DNP | 8/27/2020 | 9/9/2020 | 0.07 |
D | 9/2/2020 | 9/19/2020 | 0.94 |
FRO | 9/9/2020 | 9/28/2020 | 0.50 |
HPF | 9/9/2020 | 9/29/2020 | 0.12 |
VHT | 9/10/2020 | 9/15/2020 | 0.63 |
VPU | 9/10/2020 | 9/15/2020 | 0.89 |
FSK | 9/14/2020 | 9/30/2020 | 0.60 |
FFIN | 9/14/2020 | 9/30/2020 | 0.13 |
DNP | 9/28/2020 | 10/12/2020 | 0.07 |
HPF | 10/8/2020 | 10/29/2020 | 0.12 |