Questions tagged [pivot-table]
For questions about Pivot tables in Google Sheets or any other web spreadsheets supporting Pivot tables.
21
questions
2
votes
1answer
40 views
Dynamically reference data from multiple tabs and sort it
I've got a spreadsheet with multiple tabs of data. The data contains 2 columns, A = Categories, B = Quantity.
I've created a copy of the spreadsheet HERE (please use file > copy) if you would like ...
0
votes
1answer
35 views
Summarise data in a pivot table, but exclude certain data if it has a certain value in a certain column
I've got some data in a Google Drive spreadsheet that I want to run a pivot table on. There are 3 columns Element, Cost, Omit as per screenshot below
I want to summarise the cost by element, but ...
1
vote
1answer
30 views
Syntax of field “Google Sheets / Pivot table editor / Filters / Filter by condition / Custom formula is”
In Google Sheets, if I create a pivot table, there is a Pivot table editor I can use to configure the pivot table.
The lowest section of the interface of the editor is Filters (which allows me to add ...
0
votes
0answers
9 views
Google Sheet Pivot “% of Parent Row Total”
Can Google Sheets pivot table calculate "% of Parent Row Total"?
1
vote
1answer
55 views
Create table showing difference between values in two pivot tables
Our bookstore has two separate documents in Google Sheets (one containing purchase data and one with sales data). Each document contains a sheet with a pivot table that sums up total purchases/sales ...
0
votes
1answer
662 views
Pivot Table Filters - Custom Formula
In my pivot table, I want to only display the entries in the column "Which Event" if the name contains "Baseball" or "Softball".
I can very easily do part of this by adding a filter for the field "...
1
vote
0answers
39 views
Is there a way to create a calculated field using results of another calculated field?
Is it possible to use the results of a calculated field as part of a new calculated field? I know further calculation could be done outside the pivot table but I was hoping there was a way to somehow ...
0
votes
0answers
8 views
When setting up a pivot table in Google sheets is it possible to us if / else logic for the values
When setting up a pivot table in Google sheets is it possible to us if / else logic for the values.
For example my values data would be column L, where column K dose not equal "Total".
0
votes
1answer
12 views
Can I navigate from a pivot table back to the original database?
Once I am "in" a pivot sheet, is there an easy way to click on a row or cell in the Pivot table and navigate directly back to the related data in the original database (Google Sheet), from which the ...
0
votes
0answers
455 views
Calculated field in google sheet pivot table
I encounter a problem when trying to make a simple formula in calculated field.
I can't reference a column with a space on its name.
For example, if my column is "Column A" :
formula : "='Column A'"
...
0
votes
2answers
24 views
How to count duplicate names as one value in Sheets?
I have a large dataset in Sheets and I'm grouping together the data in a pivot table and have a hard time figuring out how to avoid counting every instance of a name instead of counting the name as ...
1
vote
2answers
2k views
Filtering Pivot table by multiple values
I have a pivot table below that I am trying to filter dynamically based on a separate list and am trying to figure out how to do this by referencing the relevant field. In the below example I have ...
0
votes
0answers
30 views
Retrieve specific value from pivot table
I have several sheets with a pivot table in each sheet.
Each pivot table has the same structure of data, with 2 columns and 5 rows:
5 labels with a numeric value and the percentage of the total ...
1
vote
1answer
147 views
Custom Script in Pivot Table Value Formula = Error Loading Data forever
I am very new to the Google Sheets platform, but I am not new to programming, and am comfortable creating and managing javascript code, and reading API documentation.
I am working on a side project, ...
0
votes
0answers
8 views
Pivot table - limit data source for detail report
Is it possible to prevent certain columns from appearing when a detail report is created?
I have a pivot table from a range of column, most of which are hidden. I would like the detail report to only ...
0
votes
1answer
638 views
How to calculate weighted average of averages in Google Sheets?
I have product review data. The reviews are out of 5 stars and I know how many there are (ie quantity of reviews). I'm trying to calculate a weighted average of the reviews because I'm trying to ...
1
vote
1answer
42 views
Can you create a pivot table in the same sheet as the data its referencing?
Is it possible to have a pivot table on the same sheet as the data it's referencing in a Google Sheet?
At the moment if I create a pivot table it always creates a new sheet.
0
votes
1answer
20 views
Aggregate data with Sheets pivot table or graph
Please have a look at this google sheet here.
It has a pivot table with 3 columns:
A period (for example: 2016/01), a category and a number. I would like to do a chart that looks like this:
For ...
0
votes
0answers
531 views
Google Chart (for pivot table) legend labels display wrong
In my Google Sheets spreadsheet, I have a pivot table, and a column chart connected to it.
But the legend of the chart is displaying not just the headings, but also the two cells below the headings. ...
0
votes
1answer
101 views
Can I eliminate redundent totals in google pivot tables?
Given the general difficulty of doing much with google pivot table, I expect the answer to be "No".
In the snippet below I would like to keep lines with the totals in green shading and not see the ...
1
vote
1answer
3k views
How can I format a pivot table with staggered elements to make narrower?
Right now a typical pivot table looks like this:
This takes up too much room horizontally. I want to format it so that it is narrower and taller, by moving nested blocks down and left.
How can I ...
