**0**

votes

**1**answer

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

**0**

votes

**1**answer

16 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

21 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

16 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

38 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

18 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

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

**0**

votes

**0**answers

24 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

24 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

27 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

9 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

22 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

15 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

39 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

8 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

36 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

40 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

21 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

24 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

27 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

24 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

36 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

10 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

24 views

### Excel: Identify source of pivot table data

I've downloaded the California State University Final Budget Summary for last year from this website:
...

**0**

votes

**0**answers

20 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

31 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

31 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

52 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

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

**0**

votes

**1**answer

32 views

### Can PivotTable create Pareto buckets?

Is there a way to use a pivot table to create cumulative buckets or brackets...from either built in functionality or a back-door method? My analysis is to show aggregate data for items that comprise ...

**3**

votes

**1**answer

26 views

### Excel 2013 Pivot table, how to filter rows/columns before pivoting

I have some raw data in my spreadsheet with columns like role, role status, object, object status, so the data indicates the relationship between role and object.
The some data view looks like
...

**0**

votes

**0**answers

19 views

### Converting traditional pivot table to data model based

When creating a pivot table, there is an option to add data to the data model. If a pivot table was originally created without this option enabled, is it possible to convert it to a data model backed ...

**0**

votes

**0**answers

37 views

### grouping columns in pivot table with data model

It seems that I lose the ability to group columns if I create a PivotTable with "Add to Data Model" option (which I need to be able to do unique counts). Is there a different way to do grouping once ...

**0**

votes

**0**answers

47 views

### hide filter in pivot table

I created a pivot table from the following data:
Salesperson | Amount | Include?
John | 100 | Yes
Jane | 350 | Yes
Jim | 200 | No
Jack ...

**0**

votes

**1**answer

115 views

### Dynamically populating a pivot table with multiple worksheets in Excel

I have a workbook that contains individual sheets for each month. Each sheet contains these columns:
Publication Title | # of Downloads | Month | Year
Each worksheet has 200+ entries, where ...

**0**

votes

**0**answers

31 views

### Excel Conditional Formatting disappears unless smaller dataset in filter

Conditional Formatting on a Power Pivot (Excel 2016 32-bit) using a Color bar is working nicely when results are page filtered to a smaller subset. But when nothing is filtered, the CF disappears, so ...

**1**

vote

**1**answer

43 views

### Conditional formatting between 2 sheets

I've got a conditional formatting question I'm really hoping someone can help with. I've got a workbook with 3 sheets - "Total Data", "Pivot Table" and "Expired Data". Pivot Table is extrapolated ...

**0**

votes

**0**answers

23 views

### Show non-value columns on the same row in a pivot table

I have a pivot table based off of the "current data", an example of both are shown below.
I want to show some columns in a tabular fashion and then show a second level of information in a pivot ...

**0**

votes

**1**answer

21 views

### Pivoting Text in Excel

I have an excel spreadhseet where I am pulling in data from an external data source. I really would like to group and/or pivot the data to use for data validation.
What I want to do is take this: ...

**0**

votes

**2**answers

18 views

### Excel PivotTable: Multiple Rows from Multiple Columns

I had the following data in Excel:
Points | Categories
---------------------------
25 | Cat1, Cat2, Cat3
15 | Cat2, Cat3
19 | Cat1
20 | Cat1, Cat3
But since I couldn't really show ...

**0**

votes

**2**answers

39 views

### How do I SUM only distinct values depending on criteria?

The question is simple but the answer probably complicated.
I have lots of data, but to be brief I gather everything in two columns.
Column A, contains random names, and column B amounts.
Based on the ...

**0**

votes

**1**answer

242 views

### Cannot sort Excel Pivot Table by two or more columns

I want to sort my Pivot Table by two columns. I've searched the web for some time, and it seems Excel doesn't allow this, so I need a workaround.
My data
Desired Outcome
I want to summarise this ...

**1**

vote

**1**answer

17 views

### name for a pivot table

is there a way to refer to a pivot table using a range name? I want to have another table with calculations based on what's in the pivot table, but I want to use range names to make sure my ...

**1**

vote

**2**answers

53 views

### Get tab delimited text from a specific column in excel

I have an MS Excel 2013 spreadsheet in which I have the list of some people attending a conference, their address, phone number etc in different tabs. Now, I've been asked to create a tab delimited ...

**1**

vote

**1**answer

26 views

### Top Percentile by Group

everyone. Can anyone please help me with the following? Any pointers or assistance is appreciated!
I have a subset of the dataset with +500,000 rows that looks like this
|— Group —|— Name —|— Value1 ...

**0**

votes

**0**answers

50 views

### The query could not be processed: File system error: An error occurred while opening the 'File Path\file_name.cub' local cube file

Please Help Me !! What happen and how to fix it ?
It occurred when I open Pivot Table in Access 2010. (My OS is Windows 10)
File Path\file_name.cub is always changed every time database is opened.
Now ...

**0**

votes

**1**answer

154 views

### Filter wrong data out of pivot table in Excel

I've a lot of data I must analyse but some data is wrong. That gives a problem for draw my pivot charts and tables. If there were no errors the chart must look like this:
But it doesn't. Here is ...

**0**

votes

**1**answer

64 views

### Cannot edit Pivot Table Style

I'm trying to modify my custom PivotTable style in Excel 2013. However, when I right-click my custom style, and select Modify, nothing happens. Normally I'd expect the Modify PivotTable Style ...