Pivot table showing wrong values

Question

I have created a pivot table in excel. My source value has a country column to show the country of each user

After converting this into a pivot table, the country value "US" in the source value shows as "r" in the pivot table, rest all the values show as it is.

I am not able to figure out why it is showing as r for US values? Can anyone please help?

Ames · Accepted Answer · 2022-07-21 04:37:09Z

2

You probably overwrite the value in pivot, where you accidentally press r while the cursor is on US in the pivot table. underlying data is still US.

Two ways that I know of to fix this, select the r in pivot and overwrite it to US again, OR rename all US to USA in your raw data and refresh pivot. Then rename it back to US and refresh pivot.

answered Jul 21, 2022 at 4:37

Ames

4802 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Pivot table showing wrong values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related