Pivot Tables & text information
Posted by Diane on April 18, 2001 11:37 AM
I am using a Pivot Table to analyze Human Resource information. Within the data set, I have 3 columns (Strength 1 , Strength 2 and Strength 3) where people are to indicate their strength from a given lists of strengths.
I would like to capture how many times a certain strength is picked and found in any of the 3 columns. How can I do it? (ie if the Strength is Customer Focus and it was chosen 4 times as the #1 choice, 3 times as the #2 choice and 1 time as the #3 choice, I want to know how to set up a function that will say Customer Focus was chosen 8 times)