Pivot table

[I89011]

Can I make changes in the pivot table, like sum?

if yes, how? if no, why not?

[#2]

@I89011 Your question makes me believe you intend to sum values but the pivot table defaults to do a count in stead. If so, that's because the part of the date you intend to sum actually consists of texts. Can you share some data? A link to the file on Onedrive, for instance. Or a similar file sharing site.

[#3]

@Riny_van_Eekelen 

I changed the values to numbers but still, I'm not getting the sum. Instead, I get a notification saying "You can't make changes to a pivot table".

Book 2.xlsx

[#4]

@I89011 

I can change from "Count" to "Sum". However all results are 0.

That is because D4:D7 is text and not number. Check with ISTEXT() or ISNUMBER().

The reason is the cells contain a dollar sign and several blanks. Remove them.