All Questions
Tagged with microsoft-excel-2007 pivot-table
56
questions
2
votes
3
answers
8k
views
Can an Excel 2007 Pivot Table merge data from different tables like a database?
I want to analyze data with a pivot table in Excel 2007.
I tried to construct an easy example to explain my question below:
I have a table (Table2) with data sorted by Person.
I want to analyze ...
- 130k
-1
votes
2
answers
1k
views
Power Pivot - Average time per item
I'm trying to calculate on average, how long it takes to make each item.
Here is the data table:
Date Item Quantity Operator
01/01/2014 Item1 3 John
01/01/2014 Item2 5 ...
- 2,602
1
vote
1
answer
2k
views
How to remove one column of a calculated item in Pivot?
I have two columns. One with data from this year and the other with data from previous year. I now have added a calculated item in Pivot to display the % delta of these two years. Now when doing this ...
- 18.1k
2
votes
1
answer
2k
views
Referenced values in a pivot table
I have a workbook that is being used by management to review data.
One sheet has a pivot table with some quite specific information.
The pivot table has multiple fields being pivoted in the rows. ...
- 23
1
vote
0
answers
276
views
Make Excel 2007 pivot tables default to Classic View
When I launch a new pivot table in Excel 2007 (.xlsx file format) the defaults appear to be:
New view (not Classic view)
Autofit column widths on update = on
Subtotals = on (top of group)
I end up ...
- 623
0
votes
2
answers
1k
views
Insert rows into a protected data table
I have a protected sheet that I've created that has tables which has some columns that I would like protected. However, I need the end user to retain the ability to insert rows into the table. How do ...
CommunityBot
- 1
2
votes
1
answer
2k
views
Excel2007 Pivot Table: Get Percentage with respect to number of different values in a field
I have a pivot table based on the answers of N persons to M different questions.
Simple Example (in reality their might be more categories for answering than "yes" and "no" and there might also be ...
- 413
2
votes
2
answers
1k
views
Combine PivotTable with prices to calculate billings by person
I have the following: date, name, item, unit, quantity, deliverer, job in a pivot table using name and job in the row field; item in the column field and quantity as the value field.
My item's ...
- 6,170
4
votes
4
answers
2k
views
MSFT Excel pivot table links to external data
Question1: What is the best online forum to ask MSFT Excel questions of the following variety?
Question2: How can I link an excel pivot-table to a potentially changing source table without having to ...
CommunityBot
- 1
1
vote
2
answers
19k
views
Excel pivot table: grand total of hours
I have created a pivot table for the following data in excel:
But as you can see, the grand total is not being calculated correctly. What should I do to fix it? My second question is, how could I ...
- 230k
0
votes
1
answer
978
views
Excel Pivot table: Calculated field based on only the first row of a group
I've got the following data and pivot table:
The Total column in the pivot table is the sum of the following calculated field:
=start-TIME(7, 30, 0)
I know that this calculation is wrong for what I ...
- 6,170
1
vote
1
answer
108
views
Excel 2007: The empty look of a pivot table
How is it that in Excel 2007, an empty pivot table sometimes looks like this:
and sometimes it looks like this:
So what's the difference? How can I make it always look like the first one?
- 800
4
votes
2
answers
1k
views
Counting "0" Stock Values Generated by Pivot Table
I have an inventory ledger. It looks like this:
Tran Type Txn Date Item Quantity
Opening Balance 6/30/12 Item1 4
Opening Balance 6/30/12 Item2 7
Shipping ...
CommunityBot
- 1
1
vote
0
answers
2k
views
Excel Pivot Table - Change default font
Is it possible to change the default font for a Pivot Table?
We have a report automation module in our application that populates an Excel spreadsheet with a result set from an Oracle SQL query.
...
2
votes
0
answers
802
views
Pivot Tables: how can I stop my columns from disappearing if they are empty?
I've ticked 'preserve cell formatting on update', but if one of the columns doesn't have an entry then it disappears. Is there any way I can keep it from disappearing even if it's blank? I suspect not ...
- 6,170