Pivot Table Not Working

[neasds]

I must be doing something wrong:

Investment

Pay Year

Ex-date

Pay date

Amount

DNP

2020​

12/29/2019​

1/9/2020​

‪0.07‬

Sum of Amount

Column Labels

HPF

2020​

1/9/2020​

1/30/2020​

‪0.12‬

Row Labels

2020​

2021​

2022​

2023​

2024​

Grand Total

DNP

2020​

1/29/2020​

2/9/2020​

‪0.07‬

AWK

0​

0​

0​

0​

0​

HPF

2020​

2/11/2020​

2/27/2020​

‪0.12‬

BX

0​

0​

0​

DNP

2020​

2/26/2020​

3/9/2020​

‪0.07‬

D

0​

0​

0​

0​

0​

VHT

2020​

3/9/2020​

3/12/2020​

‪0.45‬

DNP

0​

0​

0​

0​

0​

0​

VPU

2020​

3/9/2020​

3/12/2020​

‪0.87‬

FFIN

0​

0​

0​

0​

0​

0​

HPF

2020​

3/10/2020​

3/30/2020​

‪0.12‬

FRO

0​

0​

0​

0​

FRO

2020​

3/11/2020​

3/25/2020​

‪0.40‬

FSK

0​

0​

0​

0​

0​

FFIN

2020​

3/12/2020​

3/31/2020​

‪0.12‬

HPF

0​

0​

0​

0​

0​

FSK

2020​

3/16/2020​

4/1/2020​

‪0.76‬

VHT

0​

0​

0​

0​

0​

DNP

2020​

3/29/2020​

4/9/2020​

‪0.07‬

VPU

0​

0​

0​

0​

0​

HPF

2020​

4/8/2020​

4/29/2020​

‪0.12‬

Grand Total

0​

0​

0​

0​

0​

0​

DNP

2020​

4/28/2020​

5/10/2020​

‪0.07‬

HPF

2020​

5/7/2020​

5/28/2020​

‪0.12‬

DNP

2020​

5/27/2020​

6/9/2020​

‪0.07‬

FRO

2020​

6/2/2020​

6/21/2020​

‪0.70‬

D

2020​

6/3/2020​

6/19/2020​

‪0.94‬

HPF

2020​

6/9/2020​

6/29/2020​

‪0.12‬

FFIN

2020​

6/14/2020​

6/30/2020​

‪0.13‬

FSK

2020​

6/15/2020​

7/1/2020​

‪0.60‬

VHT

2020​

6/21/2020​

6/24/2020​

‪0.76‬

VPU

2020​

6/21/2020​

6/24/2020​

‪1.26‬

DNP

2020​

6/28/2020​

7/9/2020​

‪0.07‬

 

[DanteAmor]

I assume you want the sum of the Amount.
Apparently the values in the Amount column are text, check that they are indeed numerical values. For example, edit the cell of the first Amount and verify that you do not have spaces at the beginning or at the end, if there are spaces, delete them and press enter.

 

[neasds]

I thought the same thing but the amounts are in numerical format.

 

[neasds]

I thought the same thing but the amounts are in numerical format.

You are right. I went back and checked and they are text. Thanks.