Hello everybody!
In a pivot table, I am reporting the results of a survey question "What percentage of potential business is lost to ...xxxxxxx" and the respondent answers with a percentage. Since it is an open response that can have up to 100 different answers, I chose to use the Group function to show the responses 0-10%, 11-20%, etc. Unfortunately Excel lables the groups 0-0.1, 0.1-0.2, 0.2-0.3, etc. I have toyed with the pivot table and field properties for hours but can't get the pivot table to display the results the way I want them to be displayed.
Tips?
In a pivot table, I am reporting the results of a survey question "What percentage of potential business is lost to ...xxxxxxx" and the respondent answers with a percentage. Since it is an open response that can have up to 100 different answers, I chose to use the Group function to show the responses 0-10%, 11-20%, etc. Unfortunately Excel lables the groups 0-0.1, 0.1-0.2, 0.2-0.3, etc. I have toyed with the pivot table and field properties for hours but can't get the pivot table to display the results the way I want them to be displayed.
Tips?