Questions tagged [pivot-table]

For questions about Pivot tables in Google Sheets or any other web spreadsheets supporting Pivot tables.

16 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
24 views

Is there a way to transpose rows with an varying number of columns and replicate cells based on number of columns?

I have a Google Form featuring an name, date, and checkbox field capable of generating multiple choices, anywhere from 1 to 50. I'm looking to have this form filled monthly by hundreds of users. When ...
1
vote
0answers
25 views

How to make Google sheets refresh date filtered pivot tables when a day passes?

Google Sheets has a nice advantage over Excel - their pivot table automatically refresh, while Excel's pivot tables rely on clicking a manual UI refresh button (or - if the right pivot setting is ...
1
vote
0answers
111 views

Find Difference from Previous Consecutive Row in Google Query Pivot Table

Say I have source data like the below: OriginDate|Name|IncidentDate| where Origin Date is constant and the earliest date of my imported data set. I've formatted the dates to numbers so I can perform ...
0
votes
0answers
34 views

How to make Pivot Table repeat row labels *without* expanding all columns?

I am making a spreadsheet for doing some analytics and determining win, lose, or draw percentages. The pivot table is all fine, except that Column A is a date column, and if I choose to not have all ...
0
votes
0answers
19 views

Pivot table - Show “values as rows” on left and “rows” on right

I want to show the "values as rows" on the left side of my pivot table on "rows" on the right. In other words, I want my pivot table rows to be grouped by value rows instead of ...
0
votes
0answers
21 views

Guideline for converting a pivot table to a query in Google Sheets?

I'm running into limitations as to what a pivot table can do. Is there a ready guideline for converting a pivot table to a query? Alternately a set of examples might do.
0
votes
0answers
43 views

Google Sheets pivot table won't show totals for more than one Row item

Edit: Here's a link to the original sheet read only. The Experiment tab is the one in question. If you want to play, you need to make your own copy, then share back in your answer. https://docs....
0
votes
0answers
51 views

Show the top 1 value using pivot table in Google Sheets

I have a pivot table in Google sheet and would like to filter the top 1 item in the table. What custom formula is needed to achieve this in the filters? Sheet: https://docs.google.com/spreadsheets/d/...
0
votes
1answer
43 views

Convert table into list

I need to convert a table into a list so it can be used as a database Into this:
0
votes
0answers
629 views

How to reuse calculated field?

I have a Calculated Field 1 that I renamed to MagicPiField. I have Calculated Field 2 in which I want to use the values of MagicPiField (instead of copying the formula of MagicPiField) But when I ...
0
votes
0answers
67 views

How can I SUMIF a row, but have the formula automatically applied to all new rows below it in Google Sheets?

I've made an inventory tracking spreadsheet that gets raw data from Google Forms. Forms inputs data into Sheets in a less than ideal way, but there's nothing I can do about that, so I'm stuck post-...
0
votes
1answer
51 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
0answers
1k views

Calculated field in google sheet pivot table

I encounter a problem when trying to make a simple formula in calculated field. I can't reference a column with a space on its name. For example, if my column is "Column A" : formula : "='Column A'" ...
0
votes
1answer
34 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
822 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
1k 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 ...