
Need Excel pivot table independent columns and no sub levels
20160730
Experts: Need an help  i want the excel pivot table to show each logically independent columns next to each other instead of sub level/nested. I can surely create multiple pivot table but would be ending up having 10+. So is it possible and if yes h

Cannot sort Excel Pivot Table by two or more columns
20160106
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 by customer, sorted by number of orders, then total val

How to filter source sheet in Excel pivot table drill down?
20120629
I record my expenses in an Excel spreadsheet. In a second sheet I have a pivot table that allows me to group my expenses by month and by category to see the totals. If I double click on a cell, a new sheet is automatically added that displays a list

MSFT Excel pivot table links to external data
20090817
Question1: What is the best online forum to ask MSFT Excel questions of the following variety? Question2: How can I link an excel pivottable to a potentially changing source table without having to redraw the excel pivottable layout every time the

Excel pivot table group all months by year
20110125
I have all my data grouped by year and then sorted by month (in an Excel Pivot Table): 2007 2008 January February March ... January February March How can I group this as follow: January February March 2007 2008 2007 2008 2007 2008 I've set the colum

How can I make an Excel pivot table from very large text file?
20120524
I have a text file with tab delimited columns, that is longer than can be imported into an Excel worksheet (> 1,000,000 rows). I'm trying to figure out how to create an Excel pivot table from the data in this text file. I'm not very familiar with piv

Linux alternative to Excel pivot table
20150730
My company uses some simple MySQL queries to generate a CSV report of a bunch of stats (about 20 columns, rows in the low thousands). We then use Microsoft Excel to create pivot tables to explore and drill down into the data. I've tried using LibreOf

Excel Pivot Tables  Divide Numerical Column Data into Ranges
20110302
I have an Excel spreadsheet with a column called "Time Elapsed" that stores the number of days it took to complete a task. I would like to make a pivot table out of this spreadsheet where I divide the "Time Elapsed" column into ranges,

Excel 2007 pivot table where columns are custom values not directly in table (sort of)
20110507
I have an Excel spreadsheet that has some survey results.There are 3 questions which can be answered on a scale of 15, i.e. 5 strongly agree  1 strongly disagree. The columns are Gender and the questions, the rows are each respondent and each cell

Excel Pivot Table Date Range as Columns
20110519
I have the following data which I wish to pivot: Student JoinDate ReleaseDate John 01/05/2011 05/05/2011 James 02/05/2011 04/05/2011 I would like to create a pivot table which shows me a count of students within a given date range: 01/05/2011 02/05/2

Excel pivot table categorical variables the same in multiple columns (histogram)
20130822
I am relatively new to pivot tables, and there is one thing that I just can't figure out how to do. I have a worksheet that has several columns of categorical data. Each column (Groups 1, 2, 3) has the same type of categorical data, i.e. each cell is

Excel pivot table, difference between fields in the same column
20150413
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 Account Name Year Amount Account 1 2014 15000 Account

Excel pivot table with the categorical variables in multiple columns
20150704
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 Age_group Sex Summer Fall Winter Spring 

How to change Excel Pivot table column to text format for vlookup purposes
20140603
I have a column in my data that is ID numbers, basically. Made a pivot table out of the data. I'm trying to do a vlookup into the pivot that ignores the first number in the data like so: =vlookup("*"&A1,pivot table columns,2,false) But I get

Excel Pivot Table: Adding single column in grouped pivot table
20160122
Using a pivot table with this setup: Name Amount Total Jan Feb ... A 1 2 3 B 2 1 3 C 4 1 5 D 3 3 6 Total 10 7 17 The data is coming from a table where each "Amount" has a specific date (ex 1/1/2016, or 2/4/2016), these dates are then grouped by

How to group only some columns of the column field (Conditional Grouping) in Excel Pivot Table using VBA
20160128
I have created a Statistics Pivot Table using VBA containing EmployeeName as the Row field, Year as the Column field and Sum of Salaries as the Data field. I have to group the Years < 2000 (The corresponding employee salaries have to be summed up als

Excel Pivot Table or VLOOKUP
20110611
Students have an ID, Name, and English Level in one spreadsheet. They have an ID and achievement on a standardized test on another spreadsheet. I need to match the ID's and put the English level into the standardized test results. I was under a deadl

Excel Pivot Table  How to preserve Filter and Sorting when Data get refreshed
20140905
I have a pivot table (Excel 2010). Every Time when I update the data and make a refresh, the sorting and filters of the Pivot Table get lost repsectively I need to explicitely to modify the filter (select all, and remove the ones which are not needed

Excel Pivot Table Consolidation soing subtraction
20100205
I have one sheet for products purchased and another one that sold. I want to make a pivot table from two sheet to get current inventory for each product. But options are only sum, average etc there is no subtraction. How could I do that? I am using E