PIVOT TABLE HOW TO CHANGE THE WAY DATA IS DISPLAYED

I have a pivot table that has dept number,and a deduction number. In the calculation I want the description column displayed. I dont want the count(There will only be one description but the text of that description I found an example in SQL but I cannot find the right settings in excel.
Count of DESCRIPTION_TX      CO_C            
DED_C      6FZ      NQ1      RL9
1      1      1      1
10      1      1      1
11      1      1      1
12      1      1      1   <-----------I want this to be the text not count      
13      1      1      1
14      1      1      1


Example of descriptions  Saving 1
Checking 2
Sav/Credit Union
Checking 1
Pay Card
Serena2345Asked:
Who is Participating?
 
Serena2345Author Commented:
I did this in Access ,came out fine
0
 
karunamoorthyCommented:
can you attach the file
0
 
Serena2345Author Commented:
Here it is
pivot.xlsx
0
 
Serena2345Author Commented:
lack of resopnse for experts, I had to get this done
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.