**1**

vote

**0**answers

19 views

### Pivot table column filters

I have a list of data in Excel 2013 with dates ranging from January 1, 2014 to November 25, 2015. I want to display columns from November, 2014 to October, 2015, whether they are empty or not.
...

**0**

votes

**0**answers

17 views

### Conditional formatting of pivot table cells based on value of a separate field

I have a pivot table which has, for the purpose of this question, "document-ID" as a row label, "person" as a column label and "date signed" as value field. Is it possible to give each cell containing ...

**0**

votes

**0**answers

15 views

### How do I combine two pivot tables on a shared column in excel

I have two pivot tables that share a column of data. I would like to combine them so that the data attached to the shared column is lined up with the appropriate item in the shared column in one ...

**0**

votes

**0**answers

30 views

### Excel pivot table grouping issue with 1904 date system

When I use 1904 date system in an Excel workbook I experience a pivot table grouping issue.
After grouping for a date field in pivot table, the date values are shifted by one day.
An example of the ...

**0**

votes

**0**answers

16 views

### Get 2 graphs from the same column (dates) in 1 pivot table?

I have a constructed a pivot table, where a single column Field is filled with dates, and I would like to do a comparison between subsets of values in only this particular column.
So let's say Column ...

**2**

votes

**2**answers

74 views

### Excel survey data pivoting, plotting and analysis

I have a set of data from Google forms survey. I ran into a problem representing the data for a specific question type, grid to be exact.
So for example you get a question like this one:
and ...

**0**

votes

**0**answers

13 views

### Is it possible to pivot on a table twice?

Background:
I have three tables in my power pivot data model.
Students [1…n] StudentsClasses [n…1] Classes
Classes:
- ID
- Name
- Building
I want to do a pivot table that does the following:
...

**0**

votes

**0**answers

10 views

### How can I turn table column headers which hold dates into pivot table and be able to consolidate by fiscal year or quarter

I have a table that we use to standardize client company financial information.
How can I manipulate this table so that I can easily use pivot tables and group the dates by Year or by Quarter?
...

**1**

vote

**0**answers

30 views

### Can't calculate % of row in Excel Pivot Table

Product types A, B, C, D
Each type has numerous products, say type A has 100 products, type B 50 etc..
product# product type buyer
01 A john
02 A ...

**0**

votes

**0**answers

14 views

### Filter data from pivottable to only current day

I have a pivottable where I amongst others have a date column/row. In a regular table I can put a filter on "current day" however this is not an option in the filters for the pivottable. How can I get ...

**0**

votes

**0**answers

12 views

### Suggestions for Staging table for XML ETL?

Suggestions for Staging table for XML ETL?
Thanks for responding to my threads and looking into this issue.
We have a large XML message file. We want to extract the data from this XML file and load ...

**0**

votes

**0**answers

14 views

### Filtering Pivot Table

I have this Pivot Table, and what I need to do is: Filter this data and show only those records whose date (3rd column) is equal to its parent date (2nd column) or just 1 day difference is there.
And ...

**0**

votes

**0**answers

13 views

### Pivot Table Calculated Field

I have 2 values in my pivot, RepCount and WonOpps. I want to insert a calculated field to get the average # of WonOpps per RepCount. When I insert a calcualted field it does not sum as expected.
...

**1**

vote

**1**answer

34 views

### Calculate/determine in MS Excel which filetype/product has been ordered first (complex table)

I'm using MS Excel 2013 on a Windows desktop computer.
The original worksheet I'm working on contains about 200,000 rows, or 4,000,000 cells, and is about people who downloaded a .pdf file, ordered ...

**0**

votes

**0**answers

9 views

### Pivot Table Report Filter Field Format

In my data source I have one of the field, Delivery Date in the format of short date, e.g. 13/01/15.
I would like to create a pivot table having Delivery Date as the Report Filter. I would like the ...

**0**

votes

**0**answers

16 views

### Excel: transposing multiple entries [duplicate]

I have this kind of list
and would like to turn it into this type of list
thus allowing me to select all first occurence, all second occurence etc..
So I used the pivot table to list the ref ...

**0**

votes

**0**answers

11 views

### Failing to use a split cell range as data source for a pivottable

I want to create a pivot table from this table I have, but I want to leave out some of the rows. So, suppose I want to keep the header row, leave out the next ten rows, and use the next 10 rows. This ...

**0**

votes

**0**answers

24 views

### Connecting slicer to mutiple pivot tables

I am trying to use a slicer connecting multiple pivot tables.
When I try to connect to the other tables the list is blank. I try to connect to data sources and it shows no other data sources in ...

**0**

votes

**0**answers

22 views

### How to merge Excel PivotTable results with another sheet?

I have an Excel spreadsheet, where I have a PivotTable where the X is Location & Commodity. The Y is Fiscal Year. The cell data is a sum of Commodity cost.
The PivotTable is being generated from ...

**0**

votes

**1**answer

43 views

### Making a pivot table month filter

I'm trying to compile some reports through an Excel pivot table connected to a MS SQL database. Now the data I'm working with consists of a bunch of dates formated as dd/mm/yy. I want to make a filter ...

**0**

votes

**0**answers

15 views

### Handling exported reports from BI portal in Excel 2010 causing performance issues?

So, I'm going to try to describe this the best I can.
Multiple uses at my office will often export large reports from the BI system of the SAP web portal.
These files can be as large as 25-50mb, ...

**1**

vote

**1**answer

148 views

### Scatterplot of categorical values from pivot table

I am trying to create a scatterplot of two categorical values in Windows Excel 2013.
I tried putting the values into a pivot table, but cannot create an XY chart type with a chart that has been ...

**0**

votes

**1**answer

20 views

### Change pivot table layout into “more columns”

When I create a pivot table in excel 2010 my table looks like that:
Any suggestions how to get this extra colume filled up with the names within a pivot table?
Or do I need to use power pivot? How ...

**1**

vote

**0**answers

68 views

### Hiding pivot table field using a button

I have a pivot table in Microsoft Excel 2010 with several row and column labels. For the sake of user friendliness I would like to have several movable, clickable buttons which each hides/shows one of ...

**0**

votes

**1**answer

41 views

### Displaying data in Excel Pivot Tables

I am working on a project and being able to use a pivot table would make life much easier. I need essentially for one column to become the column labels which is fine, however I would like to display ...

**0**

votes

**0**answers

22 views

### Pivot Table loses Custom Sort Order when saved

I have a Pivot Table in Excel 2010 on which I have sorted one column with a Custom List:
Jan-2008
Feb-2008
[..]
Nov-2025
Dec-2025
This works fine until I save the workbook.
When I re-open the ...

**0**

votes

**0**answers

20 views

### Excel 2013 Pivot Charts: will not display multiple series

I have a table of data that I copied into Excel 2013. It looks like the following:
City Month Category AvgCount
Houston, TX Jan 1 0.05
Houston, TX Jan ...

**0**

votes

**1**answer

162 views

### Two-way data update with Excel PowerPivot tables (Office 2013)

Background:
We have two excel workbooks: Data and Visual which we are using to track and visualize activities in our project. The Data file is organized like a database: each sheet is a table (which ...

**0**

votes

**0**answers

148 views

### Excel 2013 PivotTable refresh slow when source data file is not open

I have an Excel workbook with ~3800 rows and ~380 columns.
In a different workbook I am using a PivotTable which references this monolithic workbook.
I am seeing an issue where if the source ...

**1**

vote

**1**answer

45 views

### Possible to create and switch between views/configurations of a pivot table

Is it possible to save different configurations of a pivot table and easily switch between them? For example, one configuration that has certain values along the X and Y axes, another configuration ...

**1**

vote

**2**answers

63 views

### How to get the count of the most frequent matching columns?

Need some help figuring out how to do this in Excel.
I have a long list of names split up into 2 columns - the first and the last name. I'd like to figure out what are the 5 most popular full names ...

**0**

votes

**0**answers

21 views

### Auto expand does not work between sheets in excel 2013?

I have a sheet with values from an access DB. As the DB expands, so does the sheet. But I also have links in another sheet to the first one, and they do not auto expand. Can anyone help me figure out ...

**3**

votes

**2**answers

433 views

### Can I customise the new Timeline slicer in Excel 2013?

Excel 2013 introduces timeline slicers for the first time. These allow you to filter pivot tables easily by selecting time ranges - either by year, quarter, month or day.
It's nearly a useful tool, ...

**0**

votes

**1**answer

40 views

### Automated weighted counts in a Pivot Table (Excel)

I have data for sales people who work with different clients. Sometimes the sales person has multiple deals with the same client. I want to be able to work out the count for each sales person for each ...

**0**

votes

**0**answers

22 views

### Show Pivot Table values as percentage of another Pivot Table's values

I have two pivot tables with identical axes to each other - a list of countries down and across either side. Each table has a count of different types of interactions between the countries as values, ...

**0**

votes

**0**answers

39 views

### Excel pivot table with the categorical variables in multiple columns

My data consists of a series of registers (patients) with some properties (Age group, Sex) and the result of four observations of the same categorical variable (Healthy or Sick):
Subject_Id ...

**1**

vote

**0**answers

154 views

### Linear date axis in pivot tables

How do I format a PivotChart so that the horizontal axis is displayed in linear time?
See the PivotTable below as well as the source data (both excerpts).
If it is in fact not possible to ...

**2**

votes

**1**answer

45 views

### Is it possible to add a custom calculation for a top level row total in a pivottable?

My Pivot Table has the following format
Manufacturer MPG
- Nissan 10
- Petrol 35
- Model A 30
- Model B 40
- Diesel ...

**0**

votes

**1**answer

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

**3**

votes

**1**answer

80 views

### Data transformation in MS Excel

looking for help on converting data from one format to another -
If you want to see data in sheet is here -
...

**2**

votes

**1**answer

68 views

### How can I use Excel to monitor my payable?

Here's what I wanted to happen, I have five columns
Supplier Amount Payment Supplier1 Supplier2
When I have a receipt of my payable, I'll encode the name of supplier and it's amount. When ...

**1**

vote

**1**answer

59 views

### Budget planning with Microsoft Excel

I have an Excel worksheet which is regularly populated with daily expenses:
Then to extract a report on the amount of money spent on each category, I simply use a pivot table like below:
I am ...

**2**

votes

**1**answer

512 views

### Excel - How to include a count of blank cells in Pivot Table?

My Pivot Table totals the occurance of various strings in my column. Some of the cells are blank. I want the "blank" category to display a total count. How is this done?
Similar unanswered question
...

**2**

votes

**1**answer

76 views

### Excel pivot table - unable to get graph to display correctly

I have a pivot table (Excel 2013) of results for a helpdesk. In column A it lists the agents, grouped by year (this divides up into months). In column 2 it lists the number of tickets closed by each ...

**0**

votes

**0**answers

36 views

### IF statement is false, do nothing - GetPivotData [duplicate]

Unfortunately, I'm unaware of an if statement that will leave a cell unchanged when the if statement is false.
Goal - If the text in Column E matches the value in B1, I want it to take the data ...

**1**

vote

**1**answer

186 views

### Data reconciliation with pivot table

I have 2 tables (table1, table2), each with 2 categorical variables/columns (product, country) and up to 5 real-valued variables to be reconciled/compared against each other (sales and other in the ...

**1**

vote

**1**answer

1k views

### Pivot table 'page fields' usage

In Excel, it is possible to create a pivot table where data comes from several worksheets. It's an old feature, but still useful. The process starts by pressing Alt, D, P. In one of steps there is one ...

**0**

votes

**1**answer

922 views

### Excel 2011 for Mac/ Pivot table / tabular layout how to “fill down?”

I've got a great pivot table in tabular layout, but how do I "fill down" values in column A?
A10 should also read "Alpaha Police"
A15:A18 should also read "Atkinson Co Sheriff"

**0**

votes

**1**answer

84 views

### Monthly Pivot Tables In an Annual Report

I was given 12 tables of purchase orders (one for each month) that my school has made and was asked to create an annual report listing purchases for each month which is pretty simple.
The thing is ...

**0**

votes

**1**answer

43 views

### Whats an easy way to fill in empty cells after copy and pasting from Pivot table classic layout?

I've run a report on products sold and used a pivot table to see products by customer. I then need to upload the data back to SF and so I have used the classic pivot table layout to be able to copy ...