All Questions
Tagged with microsoft-excel-2007 pivot-table
56
questions
0
votes
1
answer
37k
views
Excel: How to Group Dates Per Week in Line Graph
I have data that looks like this:
Actual End Date ----CP
2016-04-22------------4
2016-04-26------------3
2016-04-26------------9
2016-04-22------------7
2016-04-26------------6
2016-04-26-------...
0
votes
1
answer
2k
views
In an excel pivot table, how can I only select rows that has a particular value in it?
Here's the pivot table I have :
Mat Cust A B C D E F G H I J
1 P 0% 39% 18% 19% 0% 0% 0% 24% 0% 0%
2 Q 0% 52% 21% 19% 0% 0% 0% 7% 0% 0%
3 ...
0
votes
1
answer
1k
views
Pivot table with multiple, non hierarchical, columns
Let's say my source data looks like this:
Brand Model Color Region Sales
---------------------------------------
Ford Focus Black N/A 23
Ford Focus White N/A 2
...
8
votes
2
answers
42k
views
How to preserve sort order in Excel Pivot-table?
I have a worksheet with data that is sorted in certain order (data is coming from external source, so there are four "ORDER BY" columns that create the desired sort order but are hidden on worksheet). ...
5
votes
1
answer
41k
views
Pivot table on filtered data
Is there a way to run a pivot table on an Excel sheet that already has columns filtered?
Thus far, I've had to manually copy and paste the sheet into another sheet and then run a filter on that.
Is ...
10
votes
3
answers
65k
views
How to rotate text in axis category labels of Pivot Chart in Excel 2007?
I'm using a pivot chart in Excel to display data. My problem is: I can not influence the orientation of the text in the "axis" (don't know how to call it correctly, I'm sorry).
As an example: In the ...
1
vote
1
answer
734
views
Excel 2007 pivot table where columns are custom values not directly in table (sort of)
I have an Excel spreadsheet that has some survey results.There are 3 questions which can be answered on a scale of 1-5, i.e. 5 strongly agree - 1 strongly disagree. The columns are Gender and the ...
2
votes
1
answer
498
views
How can I use Excel to monitor my payable?
Here's what I wanted to happen, I have five columns
Supplier Amount Payment Supplier1 Supplier2
When I have a receipt of my payable, I'll encode the name of supplier and it's amount. When ...
0
votes
2
answers
337
views
Month by Month Pivot Table
I have a list of dates and data that go back a year. In Excel, I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly ...
1
vote
0
answers
1k
views
Filtering values on Excel Pivot Chart
I'm importing data into Excel Pivot Chart from SQL Server. I'm trying to filter out Values (decimal type on SQL) below a certain threshold.
For this, I click PivotChart filter and see that filter may ...
0
votes
1
answer
3k
views
Filter a pivot table based on the values in specific columns
I have a pivot table where there are multiple column labels:
group
subgroup
subsubgroup
status
The last label, status, has only two possible values, ACTIVE and DORMANT. I need to show only those ...
1
vote
1
answer
4k
views
PivotTable -- how to sum the result of a countif formula by group?
Current Setup
A table (Table1) that has the following fields:
Organization Name
Person Name
Several fields that users can put an "X" into (each represents a "module" that users would need access to)
...
6
votes
4
answers
73k
views
How can I add a calculated field to a pivot table that shows the difference between two series of data?
My underlying pivot table has the following columns - ProjectName, Type, Year, Budget. The data shows information for 2009 and 2010 for the same ProjectName and Type. I can pivot this to get a table ...
2
votes
1
answer
190
views
Combining more than 10 tables data in to one table
In Excel 2003 I was able to combine more than 10 tables' data in one pivot table through "Multiple Consolidation Range". I cannot find the option in Excel 2007. Any ideas?
2
votes
1
answer
13k
views
Pivot table with two headers in MS Excel
I'd soo appreciate if someone could help.
My initial table looks like this:
Brand Period_1 Period_1 Period_2 Period_2
------------------------------------------------------
...