pivot

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?

I m a bit stuck which way to go or which course to choose to resolve the following issue. I have a table of 1500+events in 30+topics The events took place all around the globe in the past 3years. Events were lasting 1-5 days. Locations were fixed. This system is not sustainable. So I m asked...

Hello, I'm trying to extract my max value per day from the pivot table into the line chart, how can i achieve this ? Below is my current line chart I want the line chart to be able to extract only max value per day like below Thanks in advance p;s : My data source is in dynamic range

Hi all, Using Excel365 My code is retuning an error Not sure why? I am trying to add 4 Row Fields to the Pivot Table. The first 3 are added to the Pivot, but not the 4th. I see the column in the data source I can manually drag the field from the Field List to the Rows Fields Not adding the...

Hello, I am using a pivot table to summarize some date information (about 25,000 lines). I want to pull it by our fiscal year which runs from July to June, but the default is January to December. Is there any way to set it up to pull, for example, July 2016 to June 2017, as a year? Thanks,