Questions tagged [pivot-table]

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

14 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
11 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 ...
1
vote
0answers
127 views

Is there a way to create a calculated field using results of another calculated field?

Is it possible to use the results of a calculated field as part of a new calculated field? I know further calculation could be done outside the pivot table but I was hoping there was a way to somehow ...
0
votes
0answers
585 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
13 views

Is it possible to add automatic row totals in pivot tables?

When creating a pivot table, it's possible to create automatically calculated value totals and subtotals, but it doesn't seem like it's straightforward to create automated totals for rows. For ...
0
votes
0answers
15 views

Spreadsheet formula for “un-pivoting” some 2-dimensional tables to 1-dimensional columns?

Apologies in advance for not using any correct terminology as I don't actually know the best words to describe this problem. I have two equally-sized 2-dimensional regions on a spreadsheet that have ...
0
votes
0answers
39 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
0answers
39 views

Saving tables in R

I have opened a large table using R scripts in the R GUI. Now I want to save the table in R GUI so that I can access them in the future for conducting further analysis. Please instruct me on how to ...
0
votes
0answers
58 views

Google Sheet Pivot “% of Parent Row Total”

Can Google Sheets pivot table calculate "% of Parent Row Total"?
0
votes
1answer
24 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
2answers
25 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
1answer
26 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
694 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
777 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 ...