pivot

Hi all, I have a pivot table based on stock levels over multiple weeks, most of the fields work as expected (transfer in/out, etc.) but one I'm having trouble with is 'Opening Qty'. The issue is that this field sums the 'Opening Qty' from each individual week in the range when I actually I just...

Hi All, I can define columns and data for required columns and So on for dynamin range But how do i convert it into complex charts in the excel file under Tab "Chart Data" Can anyone advise Now there are 2 questions here Can i create a chart where i can ignore blanks and N/A so my data can...

I'm learning to use PivotTable and I'm attempting to create calculated fields and change them to counts or sums, but it's greyed out? No matter which data source I use, how simple the calculation is etc. I wanted to change Sum to Average, so to get average profit and average cost per age group...

Hey, I have an excel table with invoices. Invoices has two dates, one is the date of completion, the other is the date when the invoice was actually paid. I need two different charts from this. One that shows revenues according to the first date, and one that shows revenues according to the...

Hi All, I am trying to write a script to create a pivot table for the entire data set on a tab. When I record it and run the macro on a table with a larger number of rows, the macro set the range to only include the number of rows that existed in the dataset when the pivot was recorded. Can...

Hello, I have a pivot table and my values are mostly based on calculated fields. I want to make a slicer based on the values so that it will only show based on slicer filter. Can someone help me please? Appreciate the help!

How would I go about creating a pivot table (if that's what I need) to take the values in column A (start), count them and show in a poor mans chart? Thanks Poor mans chart Input Data Sheet1 Start End 2/18/22 10:00 AM 2/18/22 5:45 PM 2/18/22 11:00 AM 2/19/22 1:24 AM 2/18/22 11:00...

HI, I am trying to return a value for a number in a string in a pivot table. Currently I've been using index/match with left but keep getting #n/a return value. Open to any suggestions :) THanks!

Thank you for taking the time to help, I am using VBA to create a pivot table that will be used to view staffing / allocations over a number of dates. The data fields presently in the pivot table macro are separated in one column grouped in rows, Position 1 through to 4. "Actual work" is...

HI, I am collecting data using Microsoft forms and the data is automatically dumped into an Excel spreadsheet as shown below in Table 1. I am wanting to pivot this table so that the data is presented as shown in Table 2, but I can not work out how to do it. Can anyone help, please...

Hi, My source data has: userid - > Departments -> week ending dates -> jobs raised I want to show the average number of jobs raised per department in each week. I don't know how to get a count of unique of user ID other than to have user ID as a row in my pivot. I need to know how many...

Hello, I am trying to figure out how to create a pivot table with date/time information and then have that information displayed as a total number of hours each day on the pivot table. In this example on 2/3 the pivot table would display 8 hours 48 minutes, 2/2 on the pivot table would display...

Hi all, I have this data sheet: I have turned it into percentages and I assume that the top value (0.36% & -1.52%) are the sums of my columns (I am very new to Pivot, sorry). But I have #DIV/0! errors! :( Is there a way in which I can implement an IFERROR formula for my entire pivot table...

Thanks in advance for any ideas you may have on my issue here: I have column ("times,") formatted as time (XX:XX:XX AM/PM) that has times in it. I have a second column ("times round,") that is referring to the first one and is ROUNDING (down) those times to 30 minutes (and formatted the same)...

Greetings All - Thank you for giving my problem a look: I have column ("times,") formatted as time (XX:XX:XX AM/PM) that has times in it. I have a second column ("times round,") that is referring to the first one and is ROUNDING (down) those times to 30 minutes (and formatted the same). I have...

Hi Everyone, I'm extracting a table with items in various statuses - To Do, In Progress, Cancelled, Done. And, I'd like ot summarize in a pivot table. However! The statuses by default are display alphabetically. So, the items are listed as Cancelled, Done, In Progress, To Do which looks...

Good afternoon, I have an excel sheet that lists user names in one column and their access level in another column. I would like to flip the data such that the access level becomes a heading and user names become a value below it. Original data User A Access level 1 User B Access level 2...

Hi, I need some help with a spreadsheet that I cannot change the source data (raw data), which is extracted from a report. Basically, I need to identify the products with highest satisfaction rating among a plethora of products, in a single column with data that goes from smartphones, tablets...

Hello everyone! I looked everywhere but did not found anything that fixes this thing! Im creating a pivot table as it follows: Dim pvt As PivotCache Dim leftCorner As Range Dim rightCorner As Range Dim completeTable As String Dim destination As String Set leftCorner =...

A B C D E Result John Daisy 00011 Britney 00100 Ronny 00100 Can we get the result in 0, 1 format by Combining Array to Text and CountA from A to E ? or if any other method?