Solved

PIVOT TABLE HOW TO CHANGE THE WAY DATA IS DISPLAYED

Posted on 2012-04-13
4
191 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
Comment Utility
can you attach the file
0
 

Author Comment

by:Serena2345
Comment Utility
Here it is
pivot.xlsx
0
 

Accepted Solution

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

Author Closing Comment

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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Recurring Excel Timelime for Veeam 2 30
Splitting out Data 14 27
Excel Macro - Lookup-Highlight 4 24
onOpen 14 38
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
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…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

744 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

10 Experts available now in Live!

Get 1:1 Help Now