**0**

votes

**0**answers

10 views

### Strange behaviour of pivot table - entry masked

I've a very strange issue in Excel 2010 pivot table. One entry of my data gets replaced to " " (space) in pivot table. "GR45ZF1402010" is not visible as you see below, if I change just one character ...

**1**

vote

**0**answers

9 views

### Pivot Table Slicers. Can I ensure one specific item is always selected?

I'm using Excel 2013.
As in the title, I have a slicer (connected to a pivot table and pivot chart) and I'd like to make sure one specific item in my slicer is always selected whilst allowing ...

**0**

votes

**1**answer

19 views

### How to sum up weighed normalizations of columns?

Say, I have a sheet with the following (simplified) structure with absolute values:
What I want to achieve is to get a table with the normalized values (i.e. the maximum is equivalent to 1. In my ...

**1**

vote

**1**answer

28 views

### Excel pivot table, difference between fields in the same column

I have table that has the same account names but for different years (sample below). I want to create a pivot item field that calculates the difference between the years for the same account name
...

**2**

votes

**2**answers

33 views

### Average of Count of Cells for Day of Week in MS Excel

I'm looking to do an average of rows per week day. And so far, I haven't been able to figure it out. I'm using Excel 2011 for Mac.
Here's a sample screenshot:
Here's the screenshot of the ...

**0**

votes

**1**answer

23 views

### Multiple Label Filters in a pivot table

Is it possible to have multiple label filters in a pivot table? I see that I can use 'contains' which could work but I am having issue with the syntax if this is possible.
I'm thinking something like ...

**2**

votes

**1**answer

25 views

### Excel pivot table: Show values instead of summaries

I have a table of data like this:
ID |Name |Brand |Model |License
------------------------------------
1 |Foo |KOM |830 AC |A
1 |Foo |KOM |930 E |B
1 |Foo |CAT |980 H ...

**0**

votes

**0**answers

38 views

### Excel Daily Average Profit [duplicate]

I have a table that looks like this..Just two column..Date and Profit:
Date--------------Profit
24 - March------25.00
24 - March------19.85
25 - March------5.25
26 - March------6.36
26 - ...

**0**

votes

**0**answers

43 views

### Multiple Values in one cell needing separate row in Pivot Table

I am looking for a solution on how to have a separate row in a pivot table for 2, 3 even 4 values in one cell.
Example - Columns are as follows: Date, Job Name, $ Value, Distributor Quoted, ...

**0**

votes

**2**answers

22 views

### Weird Calculated Field behavior in a Pivot table in Excel

Intro: I wanted to add an index to a pivot table
I wanted to add an index number (1, 2, 3, ...) to the rows of my pivot table. After some experimenting, I ended up adding a column to my source table ...

**0**

votes

**0**answers

16 views

### Excel - Grouping Columns in pivot table

I am having trouble grouping columns in a pivot table.
1.There are no blanks in the rows for the columns I am trying to group.
All fields have been formatted as General
The Range of the Pivot ...

**0**

votes

**1**answer

14 views

### Excel pivot table breaking up for whole number items

I couldn't think of a better title. Please bear with me!
I have the data as the following image shows:
I create a pivot table using the range 'Sheet1'!$A$1:$E$33. The table displayed is as ...

**1**

vote

**0**answers

46 views

### How to calculate average daily sales for each month in a pivot table

I need to calculate the averages I have in a month. What I'm expecting is to calculate 936, 184, 943, and 230 and get an average of 573.
However, when Excel calculates these values in a pivot ...

**0**

votes

**0**answers

15 views

### Pivot table not showing blank values

I'm trying to get blank values to show in a Pivot Table in Excel. I've tried all the standard options under PivotTable options without any luck. I've also tried using a custom format for the cells ...

**1**

vote

**1**answer

26 views

### Drawing independant columns in a pivot table

I have a list of items with several columns, including:
ID
date
boolean A
boolean B
boolean C
Columns A, B, and C are booleans, and I want to plot the number of each being TRUE, over time.
Using ...

**0**

votes

**1**answer

21 views

### Show Raw Data From PivotTable

In Excel, I have a PivotTable. I'd like to see all of the cells that went into individual calculation. For instance, if I would like to see all the individual values that made up B@ (Mark/Profit) in ...

**0**

votes

**0**answers

20 views

### Get original data source of pivottable

I have been sent a workbook containing a pivot table. The connection/source data used is an external database.
I am aware that double clicking on a row will drill-down into the data, but I wish to ...

**0**

votes

**1**answer

32 views

### Pivot table filter

Below is a simple representation of a huge data and its pivot table
Data
+------+------+
| Proj | Data |
+------+------+
| ABC | S |
| ABC | U |
| ABC | S |
| ABC | U |
| ABC | U ...

**1**

vote

**0**answers

37 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

47 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

17 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

31 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

18 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

54 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

33 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

18 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

66 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

42 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

78 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

28 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

23 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

343 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

37 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

19 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

20 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

39 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

126 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

35 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

27 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

17 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

295 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

**2**answers

870 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

48 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

134 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

155 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

41 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

73 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

93 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

43 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

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