formatting a pivot

This for an exercise. I am using Excel 2021 for Mac. The dataset we're given is labeled by hours 1-24 in rows and individual dates (from 1/1/20 to 12/31) in columns. It lists out all of the prices by date and by hour for "Jim's Store" and then does the same thing for "Jane's Store" directly...

Hello all, I am trying to use PivotTables to summarize and filter data. I have various tables that all do what I want, except for one. I have a list of RMs (People), their Units Under Management, and Total Claim Cost per RM. Some properties have multiple claims, thus repeating data such as Unit...

Hello, I have a Pivot Table that I created showing Year over Year (YOY) changes and I would like to sort this Pivot table to show Negative Values on top. I am showing years 2019,2020,2021, and 2022 and I would like to show the negative(YOY) for each year on top of the table. Is there a way to...

First time posting here. I'm looking for some help on how to summarize a table that is being used to track overtime coverage. The whole goal is to document how much Leadership coverage we have for any given weekend. This is something that each leader will be inputting their time into this...

Work Day values in the Pivot Table do not match the work day values in the worksheet. Some entries in worksheet show less than a full day (e.g: 0.75 of a day vs. 1 day). I tried to use the cell format function the Pivot Table, but that did not work. How do I get Pivot Table to show values < 1...

Hi, I've tried to format charts from Pivot Tabels. For some features I've found a workaround to keep the formatting sticking (after saving or slicing data) but for others I didn't. The most important feature I need to have is the colour formatting: " data series -> fill ->invert if negative"...

I'm currently pulling information from a pivot table using the following formula =GETPIVOTDATA("Account",'Debt Free'!$C$3,"Centre name","Charlestown","closedmonth","1","closedyear","2015") However I wish to change this to the following where the location is based upon two other cells...

Hello friends, I am trying to figure out how to "stack" data in the value section of a pivot table. I have data in a table that produced the follwing table. The dollar amount is on the left and the number is on the right. I would like the number to appear below the $ field, as you see in...

From reading the form I have to admit I'm a little shy to ask these two questions and not feel a little... well, Dumb. First Question: I have a set of data with column headers from A through XX. The data in each row has information about specific events over a large time frame. This data can...

I am trying to create a "dashboard" style report using a pivot table and pivot chart with slicers. All of these objects (table, chart and slicers) are in the same worksheet. However, the users of the report (read executive management) are not very Excel savvy and I want to protect the format...