**1**

vote

**0**answers

9 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

**0**answers

12 views

### Create calculated fields from column labels in pivot table

I have a pivot table like the following:
Sum of Budget Column Labels
Row Labels Revenue Expense Grand Total
2015-Q1 2000 -690 1310
...

**0**

votes

**1**answer

10 views

### Excel Pivot tables - car type and average speed - counting data according to filters

I have two columns of data: Car type and average speed (mph).
I am looking to arrange data in terms of car type and average speed. However, the average speed needs to the grouped into bins. For ...

**0**

votes

**0**answers

28 views

### Transpose 1 of 2 label columns

I have a table that has 2 label columns and then a series of data columns formatted as such. And I have nearly 20,000 rows, 900+ Accounts and 16 Quarters, so serious amounts of data. Not something I ...

**0**

votes

**0**answers

16 views

### Using a date in the Value field of a pivot table

I have a "raw data" spreadsheet with hundreds of different contracts in it. Each contract has a different contract end date (among dozens of other data points). I am trying to run a pivot off of the ...

**1**

vote

**1**answer

30 views

### Best practice for displaying and calculating data in a pivot table? [closed]

I have a data table ('Legal Fees') with three columns:
Date
Attorney Name
Hours Billed
I have another data table ('Billing Rates') with two columns:
Attorney Name
Hourly Billing Rate
I would ...

**0**

votes

**0**answers

29 views

### In a Pivot Table, how do you calculate the percentage of one value to another value?

I have a pivot based on raw data where each line is a person and their characteristics.
What I'd want to achieve:
I'd like the percentage of a value depending on various subgroups and locations.
I ...

**0**

votes

**0**answers

16 views

### Multiple Contacts for each account

I'm trying to compile the contact names associated with each account. I need the accounts to be in a list and then I need each contact to exist in a column, like so:
Customer A | Jim Dandy | Turd ...

**1**

vote

**2**answers

31 views

### How to create a pivot table on a multiple answer field?

I am keying some data and one question from the data set supports multiple answers. As best I can tell, I have the choice of keying this as a delimited column, e.g.
Answer1
------
A
A,B
C
B,D
Or, I ...

**0**

votes

**1**answer

22 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

47 views

### Advanced data consolidation in Excel

I need to Combine/Consolidate Data dynamically between over 20 separate Excel workbooks. The Column names and their relative position at the top row are the same. The positioning of each word under ...

**0**

votes

**0**answers

27 views

### Showing Zero Values in Pivot Table in Excel

I have an unremarkable pivot table in a completely new workbook. I tried both "For empty cells show 0" in pivot table options and "show blank values" in field settings to no avail. Is there another ...

**0**

votes

**0**answers

15 views

### Pivot Table line chart filter values not changing

I have an Excel table, on which I have created 3 different pivot tables.
All of these pivot tables use same set of fields from the source table.
However one of the pivot table does not refresh the ...

**1**

vote

**2**answers

107 views

### VLOOKUP or INDEX MATCH doesn't update columns when referencing pivot table

I'm going bonkers trying to figure this out. I thought I hit the jackpot when I learned about Index match and the additional flexibility over VLookup, but that flexibility doesn't seem to help when ...

**0**

votes

**1**answer

25 views

### Grouping values in a Pivot Table of data containing blanks

I am attempting to group data by range of value to create a histogram.
When I try to group a set of row labels in the Pivot Table I receive the error message "Cannot group that selection."
After ...

**0**

votes

**0**answers

14 views

### Excel 2010 - Pivot Table Inquiry

Is there a way for the report filters from the pivot table to go to the row labels whenever I choose an option in the slicers?

**0**

votes

**1**answer

16 views

### GetPivotData Number Fomatted as Text

I am using JobNumber in a couple of different pivot tables to pull out data. JobNumber is a numeric number, but Excel sometimes stores it as a number formatted as text. Sometimes I find the data ...

**-1**

votes

**1**answer

31 views

### Grand Average in place of Grand Total in Pivot Table

In a pivot table I want to change the Grand Total field to Grand Average. For example.
Row Labels Day1 Day2 Day3 GrandTotal
1 10 20 30 60
2 15 25 ...

**1**

vote

**0**answers

72 views

### Calculated Fields Reference Error (#NAME?) on Pivot Table Refresh

I'm helping a colleague fix a spreadsheet with a similar issue as stated in this ozgrid post.
The problem: Pivot table with 31 calculated fields. Some calculated fields are calculations of the source ...

**0**

votes

**1**answer

29 views

### Capturing Text from Pivot Table

I'm trying to create a pivot table that has 2 parts.
In order to push parameters into the table, you would add allows users to filter across any one of several parameters in a field. For instance, ...

**0**

votes

**1**answer

20 views

### Excel Pivot: make 1-dimensonal data 2-dimensional

I have an Excel table with a structure as follows
Customer1 Domain1 Domain2 Product1
...
Customer1 Domain1 Domain2 ProductN
Customer1 Domain2 Domain3 Attribute1
...
Customer1 Domain2 Domain3 ...

**0**

votes

**0**answers

15 views

### Sub Total previous 12 months and Current 12 months within a pivot table

I am a basic Pivot table user.
I am trying to review current 12 months and previous 12 months. I would like to sub total or group the previous and current 12 months within the table.
Can you ...

**3**

votes

**1**answer

90 views

### How to convert data in Excel to percentages of total?

Is there a quick way to convert all cell values in a table to a percentage of a total listed in a separate column? I tried posting an image of my data as an example, but my reputation here isn't ...

**0**

votes

**1**answer

421 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 ...

**1**

vote

**0**answers

34 views

### Pivot Table overlapping error

I have one Pivot Table (that used to have numerous PT's) in a sheet.
When I try to refresh, 'A Pivot Table cannot overlap another Pivot Table' error appears.
As there is only one PT in the sheet, ...

**2**

votes

**1**answer

96 views

### Excel Formula…Complex…Invoice tracking without inputting info into multiple spreadsheets

I have a list of store# in one worksheet(1) and another worksheet which has (2)invoice tracking for these stores. As the store# & invoice # are added to one worksheet(2), I want the invoice number ...

**1**

vote

**1**answer

126 views

### Use data from a drop down list to populate table

I am trying to make an employee recognition tracking tool. I would like to have in sheet 1 a drop down list of all the employees in the hotel and a drop down list of the month.
When an employee ...

**1**

vote

**1**answer

39 views

### Is it possible to make a pivot chart a subset of pivot table?

I have a pivot table and pivot chart and they are both working fine. However, I have a couple of series in the pivot table that I don't want to show in the pivot chart. I also do not want to expand ...

**0**

votes

**0**answers

56 views

### Calculated Field in Pivot Table - Reference Previous Value

I am trying to summarize data within a pivot table that was formerly calculated in excel. The format is much nicer and I believe it can be done, I just need some help.
Overview of data:
I have ...

**0**

votes

**2**answers

78 views

### Create an “inverse” pivot table [duplicate]

I have data in the following format
Project Person1 Person2 Person3
A Joe Alice Bob
B Bob Tom Joe
C Alex Alice Tom
D Bob Doug Susan
How can I ...

**0**

votes

**1**answer

38 views

### Count Row and Column in Pivot Table

Hi I have a sheet that collects the following
++++++++++++++++++++++++++++++++++++++++++++++++++++
+ Name + Address + Borough + Postcode + Date Added +
...

**2**

votes

**1**answer

47 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
------------------------------------------------------
...

**0**

votes

**1**answer

1k 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 my ...

**0**

votes

**0**answers

291 views

### Updating multiple pivot tables with slicers

I have a worksheet with about 15 different pivot tables, about 80% of them with multiple slicers. I've added rows to the data source sheet, however when I try to update the data source on the pivot ...

**0**

votes

**1**answer

70 views

### How can I use pivot table grouping by dates incremented by a day at a time?

I have some data which has been extracted from staff timesheets which provides number of hours worked by a member of staff on a given day. I need to summarise this information grouping by days but ...

**2**

votes

**1**answer

52 views

### Can I use table relationships in formulas?

Are table relationships only for pivot tables & charts, or can they be used in formulas too? The introduction of tables made it easy to write really readable sumifs like this:
...

**0**

votes

**0**answers

29 views

### Difference Between Values in Two Filtered Tables

I have a pivot table with two variables and a filter containing two distinct options. I would like to take the absolute difference between the tables created by filtering for each of these two ...

**0**

votes

**1**answer

115 views

### Adding calculated columns to Excel Pivot without details

Is there a way to add a calculated field that would apply to total column only, without adding unnecessary detail for each column item?
Consider the following example.
The data is as follows:
Year ...

**0**

votes

**1**answer

27 views

### Excel pivot table importing formula rather than value

I'm just starting to use pivot tables and I'm running into this simple issue. I have a load of data imported from a database. In one of the columns I use a lookup to convert a number into a string.
...

**0**

votes

**1**answer

679 views

### Excel Pivot Table - How to preserve Filter and Sorting when Data get refreshed

I have a pivot table (Excel 2010). Every Time when I update the data and make a refresh, the sorting and filters of the Pivot Table get lost repsectively I need to explicitely to modify the filter ...

**0**

votes

**0**answers

22 views

### Named Views for Excel Pivot Table?

While I'm an advanced Excel user and developer of addins, I apologize that I'm not very familiar with pivot tables.
I have a simple pivot table worksheet based on a simple set of data in another ...

**-1**

votes

**2**answers

251 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 ...

**1**

vote

**1**answer

336 views

### Excel Pivot Table - Average per day

I have a table of data
Date Item Quantity Operator
01/01/2014 Item1 3 John
02/01/2014 Item1 7 Bob
02/01/2014 Item2 4 John
03/01/2014 Item1 2 ...

**1**

vote

**1**answer

267 views

### Excel: How to extract group of the same rows and their values into columns?

How can I extract the second table from the first one? I need to extract those titles that have exactly three costs (in the following example: f1 and f3). I tried using pivot tables but could not ...

**2**

votes

**1**answer

318 views

### Excel Error Bars From Pivot Table

When Excel generates Standard Error error bars, it takes into account the number of data points. If a chart was generated from a pivot table, does Excel use the number of points in the pivot table, 1, ...

**1**

vote

**2**answers

134 views

### Count unique values in column B with respect to column A [duplicate]

I have two columns in Microsoft Excel, A and B. The input is displayed below
A B
ABC 1
ABC 1
ABC 2
ABC 2
ABC 2
DEF 1
DEF 3
DEF 3
CDE 1
CDE 2
CDE 3
CDE 4
I ...

**0**

votes

**1**answer

353 views

### Filtering the most recent date only in Excel 2013 Pivot Table

I have a pivot table which contains a list of customer. Under each customer is a list of dates, currently expanded. I only want to show the most recent date for each customer. Is there any way to ...

**0**

votes

**0**answers

32 views

### Reference a very large pivot table, multiple time, with complex formulas

I would like to use the data from a big pivot table I created to do more complex computation and pivot tables. I know I can reference a cell within my pivot table using the GETPIVOTDATA function, but ...

**0**

votes

**0**answers

93 views

### How do I lock one slicer, in a workbook with many slicers?

I have a spreadsheet that I have created with many slicers and pivot tables to view data more easily.
I would like to pass this to my clients, but I only want them to be able to view information ...

**0**

votes

**1**answer

44 views

### Finding Highest Value Combination From Excel Pivot Table Filter

I'm not sure if I am using the correct technique for this so please forgive me if I am way off.
I have a large range of data from previous email campaigns. I have categorised the campaigns with ...