Web Applications Stack Exchange
Web Applications Stack Exchange

Questions tagged [pivot-table]

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

A pivot table is a statistical type of table which is able to use advanced aggregating techniques to reorganize, transpose or summarize spreadsheet-like tables commonly use in Google Sheets.

50 questions
65
votes
8 answers

How to group data by month in Google Sheets

I have a Google Sheet which contains various metrics for each day. Each day has it's own row: day | cost | impressions | clicks | conversions 2014-02-01 | $45 | 3,540 | 80 | 5 2014-02-02 | $49 | 3,700 | 88 | 7 2014-02-03…
Bogdan
  • 823
  • 2
  • 8
  • 9
13
votes
4 answers

How can I group a pivot table into weeks or months?

In Microsoft Excel, in a pivot table, you can right click on the dates - while within the pivot table, on a date and select group (from the drop down menu) - then you can choose different groupings, week, month, year, etc. Then, when in the pivot…
user60173
  • 131
  • 1
  • 1
  • 4
4
votes
1 answer

Dynamically reference data from multiple tabs and sort it

I've got a spreadsheet with multiple tabs of data. The data contains 2 columns, A = Categories, B = Quantity. I've created a copy of the spreadsheet HERE (please use file > copy) if you would like to have a copy of the file to edit. I want to…
sam
  • 7,107
  • 42
  • 100
  • 140
4
votes
3 answers

Syntax of field "Google Sheets / Pivot table editor / Filters / Filter by condition / Custom formula is"

In Google Sheets, if I create a pivot table, there is a Pivot table editor I can use to configure the pivot table. The lowest section of the interface of the editor is Filters (which allows me to add filters). When I add a filter, I have to choose a…
Anthony Holland
  • 161
  • 2
  • 9
3
votes
2 answers

Filtering Pivot table by multiple values

I have a pivot table below that I am trying to filter dynamically based on a separate list and am trying to figure out how to do this by referencing the relevant field. In the below example I have the same data set and I would like to filter column…
Adam Reed
  • 33
  • 1
  • 3
2
votes
1 answer

A Google Sheet with variables for products

I manage a small business and use Google Sheets to store customers data. I want to filter and analyze that data at the end of the month for which I use pivot tables. Now, the problem is my product has different variables such as design, color and…
Aqib Farid
  • 23
  • 4
2
votes
3 answers

Summarise data in a pivot table, but exclude certain data if it has a certain value in a certain column

I've got some data in a Google Drive spreadsheet that I want to run a pivot table on. There are 3 columns Element, Cost, Omit as per screenshot below I want to summarise the cost by element, but exclude any lines that have the value "omit" in the…
sam
  • 7,107
  • 42
  • 100
  • 140
2
votes
1 answer

Create table showing difference between values in two pivot tables

Our bookstore has two separate documents in Google Sheets (one containing purchase data and one with sales data). Each document contains a sheet with a pivot table that sums up total purchases/sales by book category. I wanted to create a third sheet…
Jesse T.
  • 53
  • 2
  • 5
2
votes
2 answers

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 do this within the pivot table. Appreciate your…
Jennifer Schlarmann
  • 21
  • 2
1
vote
1 answer

Two Different Answers for the Same Simple Formula in Google Sheets

I have a spreadsheet with a very simple formula: =C4/D4 Sometimes, this very simple formula gives the wrong value. Cell C4 contains the value 390062 formatted as a number with thousands separator Cell D4 contains a formula which evaluates to the…
Clement The
  • 13
  • 3
1
vote
1 answer

How can I automatically refresh a pivot table in Excel 365 (web)?

I found https://support.microsoft.com/en-us/office/refresh-pivottable-data-6d24cece-a038-468a-8176-8b6568ca9be2#ID0EBBF=Web, which says: However, I don't see the PivotTable Tools on the ribbon, even after clicking in my PivotTable:
Franck Dernoncourt
  • 19,429
  • 42
  • 122
  • 201
1
vote
1 answer

Freeze the values ​of a slicer when I leave the sheet

I have multiple pivot tables and each of them is linked to one or two slicers. They adjust when I filter by values or conditions but when I want to go to another sheet of my document. The problem is that in a third sheet I have a table that resumes…
Ian
  • 11
  • 1
1
vote
1 answer

custom formula in pivot table google sheets

I'm trying to filter on a value in a call in a pivot table. In my "config" tab I have the following data: In my source data tab I have the following date: And in my pivot table I have two filters with custom formula: Year (formula: =…
nielsv
  • 149
  • 7
1
vote
0 answers

Slicer problems

I have constructed a large pivot table and attempted to put some slicers on. Sheets will not let me choose the specific column I wish to slice on, when I have a slicer like "Name" the slicer only shows me eight names of the several hundred in the…
Capt Samm
  • 11
  • 1
1
vote
2 answers

Converting columns into rows with different values

I have a CSV file with 16 columns. The first 10 (A-J) are contact information, the last 6 are different phone numbers, sometimes for the same contact. My objective is to create duplicates of the first 10 columns with the new 11th column (K labeled…
Gus188
  • 11
  • 1
1
2 3 4