Questions tagged [pivot-table]
For questions about Pivot tables in Google Sheets or any other web spreadsheets supporting Pivot tables.
14
questions
0
votes
1answer
225 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
22 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
7 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
11 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
2answers
21 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 ...
0
votes
0answers
23 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
95 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
478 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
41 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
19 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
478 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
43 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 ...
