**0**

votes

**0**answers

4 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 measurements of the same categorical variable (Healthy or Sick):
Subject_Id ...

**1**

vote

**0**answers

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

**-1**

votes

**0**answers

5 views

### Set range of values to include in Pivot Table Grand total

I have a pivot table with a number of columns. The right-end column is the Grand Total
How can I manually set the range of values (columns) that I can include in the Grand Total? I would need to ...

**2**

votes

**1**answer

33 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

29 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

57 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

43 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

37 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

32 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

36 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

47 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

56 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

58 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

39 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

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

**0**

votes

**2**answers

29 views

### Month by Month Pivot Table

I have a list of dates and data that go back a year. In Excel, I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly ...

**0**

votes

**0**answers

32 views

### Prevent Field Collapsing in Excel PivotTable

I am working with Excel 2013 Pro, using PivotTables. The fields in PivotTable are published into hieararchy so there are folders on top and field-values on bottom of hieararchy. What I am having ...

**0**

votes

**0**answers

17 views

### Issues with Excel pivot table denying access to original file

I currently have a pivot table that is referencing an external data source. The connection is to another excel spreadsheet on our shared server.
When importing I select the tab that I want to use and ...

**0**

votes

**0**answers

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

**2**

votes

**0**answers

38 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

25 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

188 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

51 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

44 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

31 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

227 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

61 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

21 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

19 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

86 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

31 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

28 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

52 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

27 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

64 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

67 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

113 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

22 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

20 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

88 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

38 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

172 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

83 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

134 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

29 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

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