Questions tagged [pivot-table]
The pivot-table tag has no usage guidance.
0
votes
2answers
12 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
15 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
37 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
269 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
23 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
16 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
430 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
18 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
2k 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 ...
