**0**

votes

**0**answers

13 views

### How to tell which labels have been changed in a pivot table?

I'm working in Excel 2010 with a few pivot tables where I think some wrong edits were made on row labels. I need to find the edited labels, check them for mistakes and correct the wrong ones.
The ...

**0**

votes

**1**answer

16 views

### Create pivot table with one column?

I am not even sure how to title this question. If you can give me a better title I will update the question.
Here is what I am trying to do:
Column Title: Status
A
(blank)...

**1**

vote

**0**answers

10 views

### Date axis with Pivot Chart (Excel 2016)

I have a list of dates across the X-axis of the form mm/dd/yyyy and have the pivot field formatted as a date. When I attempt to format the axis to be a date axis, Excel does nothing. I can literally ...

**2**

votes

**1**answer

28 views

### Line chart in LibreOffice - data in rows (type, x, y) rather than in a 2-input table

How do I create a line chart in LibreOffice Calc if the data is organised in 3-tuples rather than in a two-input table?
Example:
Banana Jan 10
Banana Feb 20
Banana Mar 30
Banana ...

**0**

votes

**1**answer

26 views

### Excel 2010 Pivot Table - Show Value As

I have set up a pivot table. Two of the fields are "Inseminations" and "Confirmed Pregnant" in the "values" area. They are the count of dates for inseminations and count of "1"'s as the "confirmed" ...

**0**

votes

**2**answers

43 views

### In Excel, I am trying to calculate a percentage of two sums

I have a rather large dataset, 44 columns and about 8k to 9k rows each month. The table has every trip that our customers have either completed or not shown up for. I have started with a simple pivot ...

**0**

votes

**0**answers

20 views

### Pivot Table to Show Percent SUCCESS Scores ONLY

How would I adjust the pivot table to show only the percent of scores with SUCCESS and hide the FAILS? Hiding the fails changes the SUCCESS scores to all 100%. I can hide rows in the pivot table, ...

**0**

votes

**1**answer

46 views

### Divide Sum of Field By the Sum of Another In Pivot Table Excel

How can I conduct the following calculation in pivot table? Sum the Total Hours and divide it by the sum of the Ticket Count for each Year-Month. Here's a snapshot of my spreadsheet.
The output ...

**0**

votes

**3**answers

82 views

### Excel VBA - code to skip lines / goto command

I have built a code into excel to take the data from a pivot table and insert it into a chart, a pivot chart directly linked to the table wont give me the manueverability I am looking for. The reason ...

**0**

votes

**1**answer

51 views

### Excel 2013 Pivot Table refusing to summarise identical values - returns duplicate results. Why?

I've encountered a bizarre issue whilst building a simple pivot table in Excel. Here are my data: I've created a simple table with col C containing values in A divided by those in B. I have included ...

**0**

votes

**0**answers

41 views

### Function To Lookup Values From Pivot Table

I have been trying to use VLOOKUP() to return values from a pivot table but all I ever get is #Ref I tested my theory that the issue is the fact that I am trying to return the data from a pivot table ...

**1**

vote

**0**answers

20 views

### Excel Pivot table layout for Registrant and payment data

I have data similar to this in an excel pivot table. The pivot table lays it out so that every registration number has 1 row and the person it is associated to it is in the column to the left.
Email ...

**3**

votes

**1**answer

41 views

### Can I convert a list of names directly into a pie chart in Excel?

I've asked a group of 50 students who their favourite teacher was. The survey has exported the data and I've sorted it, so the list is now something like:
Abrams
Abrams
Butler
Cromwell
Cromwell
...

**0**

votes

**0**answers

6 views

### Missing number in pivot tables that are in the underlying database. - New bug with Excel 2016, never happened in previous versions

I have used databases and pivot tables for more than 16 years and have never had a problem. Now, with the new Excel 2016 I am having repeated issues of a column or row not being included in the pivot ...

**0**

votes

**2**answers

34 views

### In a PivotChart filter, how do I select a just range in the column to display?

Help! I have created a pivot chart that shows 3 data series across iterations (time). All series are shown as 'running total in' base field: iterations.
The series are:
Total Hours Planned
...

**0**

votes

**2**answers

48 views

### Excel pivot: count of items across multiple columns

I thought this would be easy but I'm really struggling.
I have items across different columns and I need a count of all the items across each column.
Data:
Desired Pivot Table:
What I'm trying ...

**1**

vote

**0**answers

40 views

### Excel Pivot chart with a legend summary table having SUM and COUNT of values

I have a pivot chart display some data I'm interested in. Using a summary table below the chart I can plot the SUM of the values. This works great for me since the data rows contains a 1 if I want to ...

**0**

votes

**3**answers

79 views

### Transpose data from row/column that matches certain criteria

I conducted a survey that asked for a Score and a Priority for each question.
The response data lists each component in individual rows, so that it's treating Score and Priority as different ...

**3**

votes

**1**answer

50 views

### 2 columns of data in Pivot Table

I'm trying to create a pivotchart which will compare 2 sets of data in Excel. I've tried googling but everything I find either seems to require options to be checked that are greyed out for me, or far ...

**0**

votes

**1**answer

133 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

22 views

### Excel - Compute some calculus inside a CDT

I use a lot of Cross Dynamic Tables in Excel for showing my research datas.
I usually want to show a bar chart with error bar as +/- sem and for this I have to ask my CDT for mean, sd and number of ...

**0**

votes

**1**answer

31 views

### How to Sort a Pivot Table based on two columns of information

I work in the Auto Industry where I have to create a Pivot Table based on Auto information each month. The Sort Order of the Pivot Table needs to be
Model Series
Door
Cylinder
Model ID Code
Trim ...

**0**

votes

**1**answer

21 views

### Calculate additional values based on results of Pivot Table

I am trying to make a summary of some cleaning results in Excel with the aid of a Pivot Table, but I am experiencing some troubles wrapping it all up. I have the following data:
Cleaning 1 ...

**1**

vote

**2**answers

86 views

### Sort Excel Pivot Table by Percentage of Count

I have source data showing timesheet approvals in the following format (for about 850 employees and 200 managers):
Employee Name Manager Name TS Approved?
Employee 1 Manager 1 No
...

**0**

votes

**1**answer

31 views

### Aggregation of overlapping groupings in pivot table

I would like to aggregate a value of overlapping groups in a single pivot table.
An example of my data is:
Name, Value, Attribute 1, Attribute 2, Attribute 3
A, 1, True, True, True
B, 2, True, ...

**0**

votes

**2**answers

26 views

### Pivot table representing data as parent/child rather than desired summary of totals

Ok, so struggling with a pivot table and I'm not sure of how to phrase the title exactly, so apologies if it isn't 100% accurate.
Please ask for more information where it is lacking in my description....

**0**

votes

**0**answers

53 views

### Copying only filtered data with a pivot table

I've got a pivot table with data from several geographical districts (60 columns 1000s rows). I have a pivot report I run by slicing on each district, using various slicers on other columns.
I want ...

**0**

votes

**1**answer

43 views

### Excel Pivot Table - How can I return a date in the row value?

I have raw data that includes hundreds of employees who have completed many different training courses and I am needing to insert a pivot table that shows the course name as the column labels, the ...

**0**

votes

**1**answer

58 views

### Create a pivot from multiple consolidation ranges with more than one row?

I have two ranges with data like this:
I want to create a Pivot Table that consolidates the data from both tables. However when I do this using ALT+D+P I end up with Country as Row label, with no ...

**0**

votes

**0**answers

15 views

### How to calculate quarter average in a pivot table

Is there a way to show average % in a pivot table for each row of monthly averages (each month is a calculation)? It is not working.
Example: Jan = 18.8%, Feb = 60.4%, Mar = 35.8%. The quarter ...

**1**

vote

**1**answer

38 views

### Hide blank head rows in Pivot

Usually I use the filter to take out the blanks, but this is not adequate this time. Since I have three "columns" of my excel-sheet in the "Row Labels" section, called "Project-Category" (1-3), ...

**1**

vote

**0**answers

21 views

### Pivot table from multiple datasets with transpose required (Excel 2010)

I've read all the questions on pivots combining multiple datasets and have played around too and can't crack this one.
The data setup I have is (image included below):
Multiple worksheets each with ...

**0**

votes

**0**answers

7 views

### Changing format for numbers in a pivot table

I have a report where both inbound and outbound have positive numbers. How can I generate a PT so I can get either the outbound as negative numbers or the net total to show in-out?

**-1**

votes

**1**answer

47 views

### I need a way to combine identical data from many tables into one pivot table

I've been trying to figure out a way to combine data from multiple tables into one pivot table. The data from the table is populated when certain information is copy and pasted from a system that we ...

**0**

votes

**0**answers

12 views

### Possible to Rank by greatest difference in a pivot table?

I have a pivot table that gives me the difference between two time periods. I would like to rank the difference column by greatest delta. Any idea on how to go about this?

**0**

votes

**1**answer

47 views

### Excel Calculated fields on pivot table fields

I have a base data field:
Presenting Complaint | Diagnosis
complaint a | <blank>
complaint b | diagnosis a
complaint c | diagnosis b
I have a pivot table:
...

**1**

vote

**0**answers

89 views

### Pivot table with dynamic field names in Excel 2010

I am creating a workbook where the user can paste in their dataset in a worksheet. This dynamic range will be used to generate a series of pivot tables on subsequent worksheets. This works well when ...

**1**

vote

**1**answer

24 views

### Show only data from the first to last occuring month in a pivot table grouped by month and year with “Show items with no data” checked

I want to show data in a pivot table, grouped by month and year, showing items for all months, including months without data.
I followed this tutorial.
However, this doesn't work as I want when I ...

**1**

vote

**0**answers

30 views

### Expanding specific sections of a pivot table in Excel

I have a pivot table segmented by years, quarters and months. If I try to expand a quarter for 2015, however, the corresponding quarter in all other years are shown as well. How can I expand only one ...

**0**

votes

**1**answer

32 views

### I have a list of names, and tags per row (each tag is in a new column), how do I get a pivot of names per tag

My data is set up in such a way where I have
John alpha beta gamma
Mary beta gamma upsilon
Zack upsilon alpha omega
What i get is only the first column of data...
name Alpha ...

**0**

votes

**1**answer

39 views

### Excel Pivot Table - Deactivate colapse/expand function

I don't want the values to be grouped like they are here:
I don't want anything grouped with collapse/expand options. I want all columns to be filled with information in all rows, even if it ...

**0**

votes

**0**answers

42 views

### Dealing with nested columns in PivotTable

I am creating a PivotTable based on a table which features 'nested' columns as below.
...|Column8|Column9|2016 |2017 |...
... |...

**1**

vote

**0**answers

14 views

### Preserve internal order in pivot table after using slicer/filter

I would like to know if there is a way of preserving the order within a pivot table after using a filer/slicer.
More specifically, I have created a pivot that shows data being filtered by category ...

**4**

votes

**1**answer

29 views

### Excel: Identify source of pivot table data

I've downloaded the California State University Final Budget Summary for last year from this website:
http://www.calstate.edu/budget/final-budget-summaries/documents/15-16-Final-Budget&Positions....

**0**

votes

**0**answers

29 views

### Sorting in Pivot Table

I have problem in pivot table with sorting field which is shown as difference between years 2016 and 2015.
Excel 2013 make sort with original values and I want sorting by percentage difference.
...

**0**

votes

**2**answers

42 views

### Excel, Pivot and multiple row labels

I have a table with the following data
| Server | Version | DB |
| a | v1 | k |
| a | v1 | l |
| a | v1 | m |
| b | v2 | n |
| b | v2 | o |
...

**0**

votes

**1**answer

36 views

### adding a field with formula to Excel pivot table

I have the following fields in my Excel 2007 pivot table field list.
SaleDate
Amount
I'd like to add a field that is calculated from SaleDate using a formula =WEEKDAY(SaleDate) (or something that ...

**1**

vote

**1**answer

67 views

### Filter the Grand Total of a Pivot Table

I am tracking a daily compliance percentage for activities. I want to trend the monthly average compliance for the 10 tests with the lowest compliance total. I am having issues trying to figure out ...

**1**

vote

**1**answer

15 views

### calculated item for Other

A field I use for columns in a pivot table has a large number of items. Only a handful of these items are significant. The rest I group into Others. This I know how to do. The issue I'm trying to ...

**0**

votes

**1**answer

36 views

### Pivot table with 2 different sheets

I have 2 different excel sheets
tab1
A B C D E
1
2
3
and table 2
T U V W X
1
2
3
Let's say in B and U columns we have the same kind of data for instance "name of owner" and in C and V we ...