All Questions
Tagged with microsoft-excel-2007 pivot-table
56
questions
0
votes
1
answer
19
views
How to add a cell reference to Date Filter in Excel Pivot Tables
I have a date in cell C3, I want the Pivot table to only show expenses from that day. I tried entering the cell reference in this field to create a custom filter but it does not work. I also tried ...
- 23k
0
votes
2
answers
12k
views
How to get count in pivot table that does NOT count duplicate entries
I am setting up a pivot table, and I would like for it to give me the count of the number of unique combinations of two fields, not just the total count. That is, each combination should only be ...
CommunityBot
- 1
0
votes
1
answer
4k
views
Calculating a CAGR in Excel 2007 Pivot Table
I'm trying to calculate a compound average growth rate or CAGR in an Excel 2007 pivot table.
I am familiar with the CAGR formula: ((End Value / Start Value)^(1/N)) -1, where N is the number of ...
CommunityBot
- 1
73
votes
12
answers
138k
views
How to "unpivot" or "reverse pivot" in Excel?
I have data that looks like this:
Id | Loc1 | Loc2 | Loc3 | Loc4
---+------+------+------+-----
1 | NY | CA | TX | IL
2 | WA | OR | NH | RI
And I want to convert it to this:
Id | ...
- 175
0
votes
2
answers
18k
views
Refreshing Pivot Table clears Values and Column Labels fields
When I attempt to refresh an Excel Pivot table (by right click .. Refresh), all of the Column Labels & Values fields disappear, leaving only Row Label fields and an empty Pivot Table. How can I ...
- 1
0
votes
1
answer
608
views
Get count of categories present in a column in separate columns in pivot table in excel
I have a pivot table which looks like
Now I want to get count of each category in State column in a separate column. Something like this.
I tried creating a pivot table, but the format is not what I ...
- 473
1
vote
1
answer
6k
views
How to keep pivot table from expanding into occupied rows and columns
I have a pivot table with other calculations surrounding it. My issue is that if more row/column groupings are added to the pivot table, it extends and reaches the cells where these other calculations ...
CommunityBot
- 1
0
votes
1
answer
2k
views
Conditionally formatting a cell in a pivot table based on a range of cells grouped by a Column Label
Within my pivot table I currently have cells conditionally formatted- Value=1, Green and Value=0, Yellow. I would like to conditionally format based upon all the values within a row label underneath a ...
CommunityBot
- 1
1
vote
2
answers
2k
views
Excel 2007 Pivot Tables: Overlapping issue hampers my summary sheet
I've created a Workbook that has 5 Pivot Tables (PT). I want to make a summary sheet that holds all these PT's, but when they expand the 'not allowed to overlap issue' causes me updating problems - ...
- 27.6k
12
votes
3
answers
173k
views
Have Pivot Chart show only some columns in pivot table
I have a data table. In the table I have some dollar amounts. I also have formulas that use lookups to group these dollar amounts into groups in the data itself.
I then have a pivot table where ...
- 21.6k
4
votes
5
answers
66k
views
Adding a cumulative sum column to a pivot table
I have a pivot table where I am representing a series of data across a number of categories as follows:
Sum of amount Area
Status Priority Project Department 1 ...
- 7,485
0
votes
1
answer
109
views
Update table starting from today's date in Excel
I have an excel worksheet similar to the following -
Col A - Clients name,
Col B - Col D - Cient's info such as address, Phone no etc and
Col E - Date of next meeting.
I want to create a table ...
- 9,264
0
votes
1
answer
1k
views
Pivot tables: How can I total the subtotal?
My SUBTOTAL row shows Person A needs £115, Person D £234 and Person G £789, but how do I SUM those totals and get it to show the total on the same ROW?
The Rows are subscription names.
The Value ...
- 7,485
3
votes
2
answers
4k
views
How to combine multiple rows of data of a single customer in a cell as comma separated values?
I have a PIVOT table report like the one below:
Customer Name Category Date Met
-----------------------------------
Customer 1 Core 9
10
Customer 2 ...
CommunityBot
- 1
4
votes
3
answers
41k
views
Excel pivot table: How to hide zero values
I've got two tables and two pivot tables for each of them respectively. In the first table, the duration of each task is calculated on a column called "duration", but in the second one, there is no ...
