I have a data set of patient responses to a drug every two weeks for a total of 32 weeks. The response is either Positive or Negative, and I’ve created a Pivot Table where the rows are patient IDs and the columns are the weeks.

I have task items with expected deployment and actual deployment date and I want to plot these as two line charts showing when project was behind or ahead of schedule. Here is the data..

In Excel, I have a pivot table that is showing a date field column as a number. When I hover on the value it shows the date. How can I format? I already tried formatting the field as a date.

I have a simple microsoft excel table that shows sales and its date:

I have two different values for each day of the week in my pivot. Instead of each value side-by-side for each day like below, I want 1 value sat-sun then the next value sat-sun after that (instead of two days beside each other). Not too sure if there’s a way to format this?

I have a table with columns: First name, last name, course, grade, Max grade, min grade. There is a row for every course a person took. People occur more than once.

I’m trying to use data which looks like this:

I have a table in the below format:

I am trying to change the quarters in a pivot table to a different date. I want quarter 1 to start 9/1, but currently 9/1 is the third month in quarter 3.

This problem arose while I was working in the Google Data Analytics certificate program. You can apply a filter to a pivot table in Google Sheets and then use this filter to filter out rows from the underlying table (using a Less Than Values Filter). This changes the aggregated values in the Values Field column (for the SUM, COUNT, etc. Summarized aggregates).