Stack Exchange Network

Stack Exchange network consists of 174 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.

1
vote
1answer
24 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
135 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
19 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 its referencing in a google drive spreadsheet ? 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
404 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
14 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 ...