Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [pivot-table]

The 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 ...