pivot table

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

Hi all! I have a table that includes contract purchases (+$) and charges (-$). Looking for advice on what kind of helper columns, formulas or calculations I need to add to the table to give me a report that shows what the opening and closing, remainder balance is for each month... I have...

Hello Friends, I have a workbook and there is 6 question and i'm really confused abouth than so if anyone can help to ans those question I will very helpfull and appreciate your help. File Link Thank you.

Hello, I am attempting to create a pivot table that would have Conditional formatting. I can add conditional formatting to the table as a whole, but I need separate rules for each column and excel just isn't doing it. I have done all the research I could think of to figure this out on my own...

Hello, we have been using a pivot table to create interval level data for a report. The user selects which historical weeks should be considered and what activates should be included in the pivot table options. is there a way to have the selected filters published in list form? Essentially, I...

I am trying to sort pivot table fields based on sort order given in the table, however system seems to be ignoring sort order. Requesting community members to guide how to achieve required sort order in the pivot table. Sheets in the file: 1. TB- Trial Balance having GL code and values 2...

Hi all, I am fairly new to Power Pivot. I am having some trouble understanding filtering between related tables. I have my main table "Demographics", in which "Index" is Unique so: Index Role 1 Engineer 2 Engineer 3 Manager...

Hi all, I have this data, where all the rows with "Response" as "Distributed" have only blank cells next to it: RoleExperienceResponseIndexDistributed1Engineer≤ 10 YearsComplete2Engineer≤ 10 YearsComplete3Technician> 10 YearsComplete4Technician≤ 10 YearsComplete5Engineer≤ 10...

Hello! Instruction say I have to put the 'Total Price' (which is a calculated field) onto the 'Values' of the Pivot Table. The formula I used for the 'Total Price' is "=UnitPrice*Quantity". I manually Calculated the "Los Angeles - Whole Wheat" (293.16) as well as the "Total Whole Wheat on the...

Hi All, I am trying to do the following, please let me know if this is possible: I have a "Value Field" called Count of Value_Proficiency which simply counts the occurrence of each Row Label I would like to create a new "Measure" having Max of Count of Value_Proficiency repeated for all Row...

Hello, I have a question on pivot charts. Let's say there is a pivot table with 3 columns. 1st:Issue name, 2nd:opened date, 3rd: closed date. The column with closed dates contains blank cells. I want to make a chart with 2 lines. X axis with dates and Y axis with number of issues. Each line...

I am trying to write some VBA to loop through a PivotTable, and I am struggling with the appropriate objects and names. My PivotTable has a handful of filters (the code needs to be able to accomodate a changing number here), 7 row fields (this will be unchanging), and one column field (the one...

Hello, i'm looking for help with creating a loop for creating pivot tables and also some help in defining how graphs are arranged. The workbook i have works ok, however i am manually creating a pivot table for each Toy category in the data table. When more Toy categories are added i would like...

Hi All, I recorded a macro to see if there was a way after I inserted 3 slicers, to select report connections for each of the slicers to select pivot table without having to right click and select report connections for each slicer. This is the below macro code from the recorder: Sub...

I am trying to use the getpivotdata formula to use the data from a larger pivot table. If I use the formula that excel gives me when I put =and click the value i need it looks like this "=GETPIVOTDATA("[Measures].[Count of Training Start]",$A$3,"[Table4].[Manager]","[Table4].[Manager].&[C...

I formatted row labels (see image below) as number in original table and checked with isnumber. However here in pivot table they behave like text. I want to sort them descending.