pivot table

Hi Excel Gurus, I have a spreadsheet, two (tabs) are data input manually. I used a power query to format the data. Then I used a pivot table. To refresh the table, I must select "Data > Refresh All" Is there a way to display the last refresh date and/or refreshed by who? for when my pivot...

Hi There I have a Pivot where in the "Columns" Strategic Region as 3 Regions (Emerging, Europe, North America). There are 2 attributes I want to bring data in under "Values (Sales Amount T1 LY and Sales Amount T1 YOY). As you can see the pivot is pushing the Grand Totals for the 2 attributes...

I have a Pivot Table that by default lists months with January and February listed before November. I have searched thoroughly, both online and within Excel, but have not found how I can sort so that Nov 2022 and Dec 2022 precede January 2023. The time field that the Pivot Table is pulling from...

Hello All, I have 3 files have different data formats and fields. There is one common field amongst the 3 reports. The Location ID. The three Files would have different details each of which are connected by the Location ID. First one, the employee register. Second is the Monthly Costing...

Hi everyone, I have the following data set, that I plan to continue adding lines to throughout the year. I want to create a pivot table where I can see the success rate (where booked = Y) for each combination. For example what percent was booked in January through google for a brand. The...

I would like to create a pivot table that looks like this: ABCDEFGHIJKLMN1JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotal2Felix S3 Yearly Salary$ 56,000.00$ 56,000.00$ 56,000.00$ 56,000.00$ 56,000.00$ 56,000.00$ 56,000.00$ 56,000.00$ 56,000.00$ 56,000.00$...

Hi, I am trying to calculate averages per site requiring use of the distinct count function. I've used the following calculations to determine these averages: - Total count (calculated using the sum total) - Column 2 - Survey count (calculated using distinct count) - Column 3 - Average count...

Hello Everyone, I´m having an issue with a pivot table from the data model. I want the quarterly subtotals to show monthly average rather than sum, but the option is grayed out: Is there a way I can work around this? Thank you!

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...

I have a table that has columns for tracking weather via METARs. METARs are messages that are used by aviation to pass weather readings. They are usually generated hourly, unless otherwise required, every day. I have a table that has 99K rows of data. Each day has between 22 - 28 rows of...

I have a pivot table connected to a data model and I keep changing its shape according to my needs, it would be helpful to have a way of bookmarking a certain layout an putting in a name instead of duplicating the pivot table tab and having a dozen of duplicated tabs, will the spreadsheet get...

Hello, I have a power pivot table I am using to summarize some data. I am using it as a daily report and outside the pivot table I pull out and summarize specific data related to individual departments. Two of the Lines I want to combine the total units produced. Which works fine, when both...

Hi I have created two pivot tables from two different data sources. These data sources have one thing in common which is that both have column with date. I want to have one "master" timeline that would control both pivot tables. I am assuming I would need to create VBA module to control it...

Hi, I have a table in the following format: DateInserted IdentityNumber TeamName MMYY 21/12/2022 0101040504 Team A Dec-22 10/05/2022 0101590849 Team A May-22 07/06/2022 0101632916 Team A Jun-22 06/06/2022 0101750412 Team Z Jun-22 25/10/2022 0101770383 Team B Oct-22 22/12/2022...

Hi all, I need your help with a table I'm trying to build and need to run it every Monday. I think this can be achieved with VBA. What I need to do: - At the beginning of every month, the table needs to erase the details (or simply don't take in consideration the values as I only care about...

Hi All, I have a pivot table aggregating quarterly data of number of employees at multiple sites. In order to analyse this, I need to know the average number of employees in each quarter to use in an injury rate calculation. I am trying to use a calculated column in the pivot table but this...

Hello and thank you in advance if you're reading this. I think it will be fairly easy to solve but my Excel knowledge is limited. I work at a production company that can fit 39 "sponges" into one shipping box. Because a production run total changes based on the amount of material we have, the...

Hi, I have a data table where I have sales for an item in 1 row called focus (that is this years sales) and then the next row gives me the comparison sales (this is last years sales for that item). I am putting a pivot table together that looks like this but have not been able to figure out...

Hi, I have a workbook where the first sheet ("main") is a sheet with pivot tables based on the data in each other sheet in the workbook. These other sheets are data sheets (by date) extracted from an external database. I add them to this workbook every day as follows: [ main ] [ 20230110 ] [...

Hello experts, I have a data representing the purchases of each customer per category. Customer Category Food Category Clothing Category Electronics John Bananas Hat Laptop David Meat Jacket Peter Tshirt Headphones Andre Fish Jeans I would like to have a pivot table to show...