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

  7. current community

    your communities

    more stack exchange communities

    company blog
Web Applications

Questions tagged [pivot-table]

The tag has no usage guidance.

8 questions
info newest frequent votes active unanswered
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 ...