pivot

Hello if I group data on a pivot table ie a Monday for 7 days do you need to put an end date of a Sunday or will it just fill up to the end of the table data?

Hello Experts, I am working on a budget file where users are given an excel template to fill in Budget data for each line item as follows ( I have give We have another deptt who give us the erp based report where actuals which are booked under the planned head as follows we are doing this...

I have a spreadsheet that I haven't refreshed since the middle of November 2022. When I refresh the data today, the chart shows every month instead of only the filtered month! Has something changed in excel since November 2022? This used to work, but now doesn't, and all I did was RMB...

Hi, I am new to VBA and I am trying to run a routine that selects the grand total in a pivot table. When I try to record the Macro, I can select a cell (like h9) but not the grand total of a specific 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...

Hi, I've just started trying to use pivot tables. I surveyed some students using Forms and have downloaded the results. One of questions was "how do you rate the following in importance" Job Security, Co-workers, Public Facing, etc etc. So assentially they had 10 questions that they could...

Hi everyone. First post here, so please let me know if anything is not according to the guidelines. This is a snippet from a table in which data is collected from the brewery I work at (not all columns are depicted): batch # tank numberbrew dateempty...

Full disclosure, I'm not a pivot expert - I created this table attempting to replicate a Crystal Report, and while I've been 99% successful there's a big formatting issue - the fund numbers keep repeating when I add a new column. The columns where this issue starts are calculated fields. I'm...

I have a large spreadsheet containing multiple pivot tables. Something in the spreadsheet (I assume a pivot table) is pointing to a file that doesn't exist anymore. When I click Refresh All to update the pivot tables, I receive an error "Sorry, we couldn't find <path and file name of the...

I'm sure this is an easy one, but I can't wrap my mind around it. I have a data table like this (sorry for the image, the XL2BB macro isn't activating for me) Here's what I'd like the pivot table to summarize for me: the number of Pass's and Fail's each student received on each date. Just...

I often have to copy data from pivot tables in order to make sales reports later. In the pivot table, my data is structured according to the following hierarchy: Brand name-season-category How can I copy the data from the pivot table so that the data is like in a regular table, but the...

I work as a sales data analyst for a clothing manufacturer. And I often make sales reports that are structured by Brand-season-Category. I constantly have to manually select rows and group data. Maybe there is a way to write a macro to do this automatically ? A macro with constant strings will...

I´ve a problem with one of my pivot table. I can´t really post the excel since it contains sensitive information but i´ve attached an image of the problem. The problem is that dates from my raw-data sheet is displayed twice in my pivot filter section. There is 10 cells with information but 20...

I am currently looking to calculate a savings percentage. To do this, I have created a pivot table that adds Column A- All of Company A’s billed costs. Column 2- All of Company A’s reviewed cost savings Basically, there is a review process and column two has what we were able to reduce based...

I have a GSheets pivot table that shows me tag usage and the dates used, there is no need for columns I simply have rows defined for tag and date used. This gives me the list I need (almost). I want to find the first date of use, so the second column of the pivot shows me all dates use and the...

Hello. I have a pivot table showing monthly revenue for fiscal year beginning Jul ending the following Jun. How would you add a calculated field to show projected year-end total based on Jul-Sep total, plus the projected revenue from Oct to Jun, based on the Sep value, assuming the Sep value...

Guys, here's my issue.... I have this data grid that I need to pivot it. Simple. The problem is that the dates comes across (toward the right) of my main columns. Usually, I'd rearrange my data in a vertical rather horizontal direction BUT It cannot be moved as per client's request. Well...

I have tricked a pivot-table to search in value fields and item-fields like a manual auto-filter. I did this by applying a manual Autofilter on the Pivot Table by using this solution. Now I can filter all columns like a regular AutoFilter which simply hides the rows during a filter instead of...

Hi, I am add a simple sum calculation to a pivot table which will multiply column 1 with 2. I have added a calculated field with the following formula ='Unit'*Quantity However i have noticed that a lot of the totals are showing incorrect. Is there a different method to calculating this? Thanks

Hello, i have a question for a practice interview test which is On the ‘Workings’ sheet use formula and/or pivots to analyse this dataset to identify the percentage of students still retained and graduated at the end of the third year (by course) and the proportion of graduates that received a...