nmichele
asked on
Pivot Table values are repeating
Hi,
I'm generating a Pivot Table but the values for Household size are repeating, i.e. are not unique. Please see attachment.
I would like values in that column to be unique, and to be sorted in order. Currently the sorting is not correct, e.g. 11 appears before 2
household_size.png
I'm generating a Pivot Table but the values for Household size are repeating, i.e. are not unique. Please see attachment.
I would like values in that column to be unique, and to be sorted in order. Currently the sorting is not correct, e.g. 11 appears before 2
household_size.png
ASKER
Hi Rgonzo,
I've attached a screenshot.
I've attached a screenshot.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Could you send a dummy?
Regards