icytuvi
New Member
- Joined
- Feb 2, 2020
- Messages
- 31
- Office Version
- 2013
- Platform
- Windows
Hi there,
I am given a ready-made pivot table having a field with incorrect information so I want to make correction on the source data
(i.e in the below example Banana should be categorized as 'Fruit' instead of 'Vegetable')
However, I cannot find any column in the source data representing the 'Category'.
I have checked to make sure no column is hidden and even checked on the Named Ranges, but found nothing. It is as if the categorization is browsed from out-of-nowhere~~~
Do you have any idea on how I can locate it?
Thanks a lot.
I am given a ready-made pivot table having a field with incorrect information so I want to make correction on the source data
(i.e in the below example Banana should be categorized as 'Fruit' instead of 'Vegetable')
However, I cannot find any column in the source data representing the 'Category'.
I have checked to make sure no column is hidden and even checked on the Named Ranges, but found nothing. It is as if the categorization is browsed from out-of-nowhere~~~
Do you have any idea on how I can locate it?
Thanks a lot.