2
votes
1answer
32 views

Excel 2010 Pivot Formatting - Can't indent and wrap fields?

When working with pivot tables in Excel 2010, I want to show my pivot in compact form, with each field being indented as you move through the data, like so: However, some of my data strings are ...
1
vote
0answers
30 views

How to add custom columns to Pivot Table (similar to Grand Total)?

I have data which I pivot as Row Labels and Column Labels which gives me something like this: And what I would like to do is add columns like Grand Total (i.e. which applies to all columns as a ...
2
votes
1answer
41 views

How to Make a PivotTable out of “hierarchical” Excel spreadsheet data

I would like to create a PivotTable out of "hierarchical" data contained in an Excel 2010 worksheet. The data is hierarchical in the sense of a parent/child relationship in a database where, ...
0
votes
1answer
44 views

Excel: How to clear all renamed PivotTable labels

When using PivotTables in Excel, it's often useful to overtype certain PivotTable labels with new names. If you have a long list of items you've relabelled, it can be easy to lose track of what the ...
1
vote
1answer
27 views

How can I summarize cells based on date in other cell?

I have one Excel sheet with columns "project name", "project date", and "effort estimation". On a second sheet I want to summarize those projects according to the months of the year. So I have ...
0
votes
1answer
19 views

Can't apply value filter to excel pivot table without affecting subtotals - Subtotal filtered items greyed out

I have a pivot table containing a list of assemblies and the costs of the parts, with the subtotals equating the total cost of the assembly. I want to filter out the parts of negligible cost (say ...
0
votes
1answer
22 views

How can I in a pivot filter detail to show new accounts in current month with sales where all other months show no sales?

I have a pivot table which is huge with raw data has more than 800,000 lines. I have customers in the row labels and month or year in the column labels. Each month this pivot tablr grows adding on ...
2
votes
1answer
46 views

Excel 2013 table formatting

I currently have a table that looks like this: Company | 2013 Total | 2013 Gross $'s | 2013 Gross % | 2012 Total | etc.. | | | | | ...
0
votes
1answer
24 views

How to prevent all-filtered-out row label values from appearing in a pivot table?

I have a pivot table in MS Excel. For the same of example, suppose the basic data has 3 columns: Name: A string. CountMe valued either 0 or 1. Year an integral number. Tokens the data we're ...
1
vote
0answers
19 views

Make Excel 2007 pivot tables default to Classic View

When I launch a new pivot table in Excel 2007 (.xlsx file format) the defaults appear to be: New view (not Classic view) Autofit column widths on update = on Subtotals = on (top of group) I end up ...
1
vote
0answers
45 views

Using getpivot in excel to create flexible reports based on user inputs

I am trying to make a report in Excel that sits on a very large set of data (set up in proper pivot form). I want to be able to select a value for a few fields (or select a value from 1 field but ...
1
vote
1answer
58 views

Excel pivot tables: reverse running total

Is it possible to create a reverse running total in an Excel 2010 pivot table? Using the basic example below, I have a list of number of sales per month (B), along with a running total (C). Without ...
1
vote
0answers
51 views

How do I find which Pivot Tables has an error in Excel 2010?

I'm receiving an error: cannot open PivotTable source file ...XLSX SHEET... while refreshing all data. I have many Pivot Tables, and I can't find that one with the error, while refreshing ...
1
vote
1answer
233 views

Sum two columns of a pivottable into a third column

excel file pivottable screenshot I have an Excel spreadsheet (above, with screenshot). There are three columns of data, A, B, and C. A fourth column, Combined, simply contains a formula that SUMs A ...
1
vote
1answer
91 views

How do I create a PivotChart from a subset of PivotTable data?

As part of a dashboard, I've created a PivotChart from a PivotTable in Excel 2010, but the PivotTable includes extra columns that are cluttering up the chart. But when I adjust the values list on the ...
0
votes
0answers
154 views

“Reference is not valid” error when refreshing pivot table

I have a .xlsm file on a network drive (source.xlsm for example) with a table that serves as the source for pivot tables that live on various other files (localfile.xlsm for this example). When I try ...
0
votes
2answers
247 views

Count and percentage with Excel pivot table

I currently have three sets of columns: Several columns with values of either true or false to indicate if a certain action has taken place. "Helper" columns which interpret TRUE as 1 and FALSE as 0 ...
2
votes
0answers
34 views

Display value in associated row in pivot table

I need to display a value in the same row of data as my minimum value in a pivot table. For example, my pivot table looks like: Row Labels Min of 247 1950 255.42 1951 250.46 1952 ...
0
votes
0answers
162 views

How do I change dates in a pivot table using VBA?

How do I automate the checking/unchecking of dates in a pivot table? I have a pivot table from which I need to extract data based on a date range (last seven days, previous seven days). The ...
0
votes
0answers
111 views

Excel VBA: Is it quicker to refresh all PivotTable caches than all PivotTables?

I'm new to all this VBA/macro stuff, and while I was looking for code to refresh all pivot tables in my workbook, I came across some information about PivotTable caches. I have ~14 PivotTables in ...
0
votes
0answers
133 views

Hiding a column from a pivot table without removing it from the chart

I have a pivot table with two columns: number of users who visited a website (impressions) and number of users who registered on the site (regs). The rows are for dates. I want to visualize the ...
2
votes
1answer
1k views

How to change Excel Pivot table “Report Filter”s values cell formatting

My Excel is in Finnish, but don't let that bother you... First Report Filter "Kupi" has only number values in my source table, for example 643203, 3533, 253244, etc. How ever in Pivot's "Report ...
3
votes
0answers
378 views

Excel 2010 crashes: Excel.exe 0xc0000005 when trying to highlight from pivot table

One of our users uses pivot tables a lot. She often called me about Excel crashing from time to time without being able to reproduce the problem. Today we have found a way to reproduce the crash every ...
2
votes
0answers
90 views

How to sort time column by value instead of alphabetically

I'm creating a pivot table by connecting to an SSAS tabular model (Data -> From Other Sources -> From Analysis Services) . The model has a "time" column that I want to sort by. The default (database) ...
3
votes
3answers
2k views

Excel 2010 PowerPivot: How to show items with no data?

In standard Excel pivot tables, there is an option for fields that allow you to force display of all items even if there are no results for your current selection. Here's the option: However, using ...
1
vote
1answer
64 views

Calculate frequency across columns

I have meeting attendance data currently formatted as lists of ID numbers of the members present at each meeting: 9/21/13 | 9/22/13 | 9/23/13 123456 | 408437 | 123456 408437 | 349343 | 349343 ...
0
votes
0answers
67 views

Excel 2013 Pivot Table Datasource without filename

I'm building a Excel spreadsheet containing some Pivot Table based on a table inside the document. It's working file as long as the document path and filename is not modified. However, if I copy ...
0
votes
0answers
96 views

calculated field to a pivot table that shows the difference between data of different years and diffferent columns?

How can I add a calculated field to a pivot table that shows the difference between two series of data of different years and columns ? My underlying data has project_name, Year, Actuals, Forecast . ...
1
vote
1answer
2k views

Excel pivot table categorical variables the same in multiple columns (histogram)

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 ...
1
vote
1answer
71 views

Aggregating Columns In Excel

I have data consisting of a date and a list of purchases, something like this (commas represent separate columns): **date,product1,product2,product3** 08/11/13,oranges,apples,chips ...
2
votes
0answers
431 views

Pivot table : absolute value of grand total in Excel

My grant total is generated by summing values of COLUMNS of ITEMS for a given SUBJECT (For each SUBJECT I have a list of ITEMS and I want to make a grand total of the values of these ITEMS). The ...
1
vote
1answer
588 views

PivotTable — how to sum the result of a countif formula by group?

Current Setup A table (Table1) that has the following fields: Organization Name Person Name Several fields that users can put an "X" into (each represents a "module" that users would need access ...
1
vote
0answers
288 views

Excel - One Slicer To Rule Them All

In excel I have multiple sheets with different pivot tables and charts. Each of the sheets has different slicers, but they all share one in common. I would like to make a global slicer on my main ...
0
votes
0answers
322 views

Pivot Table from data with merged cells

I have a energy spreadsheet for multiple sites. the first row has month and year. the next row has columns for date invoice received, KW hours and cost. So there are three columns for each month. I ...
2
votes
1answer
4k views

Can I force an Excel 2010 Pivot-Table to display text strings from my raw data?

Here is my use-case. As a training specialist I want to look at a single tab in Excel and see student feedback at a glance. I want to see pie-charts showing who said "Yes" this course was a good use ...
0
votes
0answers
97 views

Can I paste multiple filters to a pivot table?

Is there a way in Excel to paste in multiple items as pivot table filters? If I have a list of 15 codes out of a larger set of possible values, it's tedious and error-prone to scroll around to find ...
1
vote
1answer
716 views

Excel - Finding all values in one column for unique values in another column

I have an Excel table that looks like this: Code | Description ------------------------- A | Desc1 A | Desc2 B | Desc3 C | Desc4 C | Desc5 C | Desc6 ... I need to find all the ...
0
votes
2answers
44 views

Manually populate a Pivot Table

This is really a stupid question because I am supposed to know the answer. I have a data file that looks like this: Tech || Workdate || Fail || Manual Joe || 2013-05-23 || 6 || 1 Joe ...
0
votes
1answer
121 views

Pivot table on filtered data

There doesn't be a way in Excel to run a pivot table on an Excel sheet that already has columns filtered. Thus far, I've had to manually copy and paste the sheet into another sheet and then run a ...
0
votes
2answers
352 views

Excel use columns in one table to make another table

I have an csv data dump which is a flattening of related tables from a sql database. So to simplify it looks like this. | col1 | col2 | col3 | col4 | +------+------+------+------+ | A | Ad | B ...
2
votes
1answer
243 views

Excel formula return that pivot tables will handle like cleared cells?

What combination of techniques with cell formulas and pivot table configuration will enable the drill-down into the pivot table to only show rows containing the 'desireable' valued cells, ignoring the ...
2
votes
1answer
1k views

Grouping a field in one pivot tables groups the same field in another table

I've got a data sheet, which basically contains an amount and a date. I've created several pivot tables, each on one sheet. I have given names to those tables, such as "tab_days", "tab_weeks", ...
1
vote
1answer
92 views

How to group daily data by month

Have a somewhat unusual Excel question: I have a column of data that only has values of -1, 1, or 0: | X | | 1 | | 0 | |-1 | | 1 | | 0 | | 1 | I also have daily dates associated with each row, ...
2
votes
1answer
181 views

How to make a pivot table with two sets of columns, each filtered differently

Suppose I have the following Excel data: +------+-------+--------+ | Item | User | Status | +------+-------+--------+ | MTB | Bob | A | | QCD | Bob | A | | MTB | Alice | B | | ...
2
votes
1answer
149 views

Referenced values in a pivot table

I have a workbook that is being used by management to review data. One sheet has a pivot table with some quite specific information. The pivot table has multiple fields being pivoted in the rows. ...
0
votes
1answer
3k views

How can I edit the legend in an excel pivot chart 2010

How can I edit the text of the legend in an Excel pivot chart in office 2010? It is a workbook that only has a pivot chart with no pivot table. Cheers
1
vote
1answer
65 views

Excel_macro_pivot table_analyzing data

I have two problems with my data in Excel. I have this table, so for every day in the year I have got 24 values, that´s 365 columns. I need to write a macro, that transform the data vertically, ...
0
votes
1answer
48 views

Excel pivot diagram is way too wide

Every time I refresh my pivot diagram, the diagram expands and becomes as wide as four times the screen width. How do I stop it from acting crazy?
0
votes
1answer
477 views

Single source worksheet, and multiple pivot tables using filtered data

How does one manage to create a workbook, where one worksheet is the master source data, but multiple pivot tables need to be created with the same set of "row labels" and "summed values", but ...
0
votes
1answer
235 views

Sort Excel Pivot Table By Month

I am trying to sort data in a pivot table. I am hoping to end up with a table that has row labels with my data types, and then 12 monthly columns with a count of each type in each column. So far I ...