Solved

PIVOT TABLE HOW TO CHANGE THE WAY DATA IS DISPLAYED

Posted on 2012-04-13
4
194 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:Serena2345
  • 3
4 Comments
 
LVL 7

Expert Comment

by:karunamoorthy
ID: 37843740
can you attach the file
0
 

Author Comment

by:Serena2345
ID: 37843836
Here it is
pivot.xlsx
0
 

Accepted Solution

by:
Serena2345 earned 0 total points
ID: 37844011
I did this in Access ,came out fine
0
 

Author Closing Comment

by:Serena2345
ID: 37859717
lack of resopnse for experts, I had to get this done
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now