pivot

Hello, I have a data table with the start date and another column that uses several formulas to extract the month and year from the start date. I created a pivot table with the data set but the date columns are being shown out of order. I have tried formatting the column as dates but the result...

I have a pivot table (Columns are Name and marks) and I have created a dropdown that contains a list (Alphabetical, High to low, and Low to high) If I choose Alphabetical my pivot should get sorted in Alphabetical order by Name column If I choose High to low my pivot should get sorted in...

Hi Everyone, Looking for an answer & help here, I've never seen this kind of fields in Pivot, 1. how do call it? any source link to read? 2. It's from a .CUB files, can we create these from .CSV raw data? 3. Tiempo is an aggregate from Column Year & Month in the CSV, how to create this? Thanks...

Using Excel 365 I have a data set that contains a "month" column formatted to "MMM-YY". When I pull this column into the filters section of my pivot table, the options are: "<29/02/2016 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec >01/07/2023" How do I get it to show my desired...

Good day! Can you please help me with a question on Pivot table Filters? Taking below as a simple sample. There are (Multiple Items) in the Month ("1987-09" and "1987-10"). Is there any way/formula that I can get the filter set? (to return the values as "1987-09" and "1987-10") Thank you...

I'm trying to write a macro that involves copying data from a pivot table into a separate table. I'm hoping to keep positive and negative values separate because I'll need to sub those negative values multiple times for the data to be accurate and the "Label Filter" option seems to be for...

hi guys, i am SUPER bad at pivottables i have this dummy data for a loan here in my sheet: I essentially would like to create a slicer for "Status" that can filter for this table. However, in order to do so, it seems that I have to make a pivottable? I like my current formatting, but if I...

Hi everyone, My question relates to dynamically expanding the range on a pivot table when new columns are added as part of a separate pice of code, then adjusting the range of a chart to now exclude a previous column, and include one of the new columns (containing a copy of the previous data...

Hi! how can I reorganize the order of the pivot fields: Client Type, Product, Side. When I run the below, the rows are in the following order: side, product, client type: 'START pivot ActiveSheet.UsedRange.Select ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _...

I'd like to create a pivot table where column names and data values in the original data table become row headings and column headings in the pivot table:

Hello. I have a worksheet with my raw data on. I successfully created two PIVOT tables on new worksheets. I then deleted the worksheets with the PIVOT tables on because I wanted to start afresh. Excel won;t let me insert a new PIVOT table now. I get the error message "The PIVOTTable field name...

Hi, Good day, I am currently working with a large dataset and am utilizing a Pivot Table to better organize the information. I was wondering if there is any way for the summarized data from the Pivot Table to be sent to a new sheet and then printed with the formatting and other adjustments...

Hi Excel Gurus, I created a spreadsheet... (tab 1) - Source Data (OLD data) (tab 2) - Source Data (NEW data) (tab 3) - Power query to combine (tab 1+2) Old and new data (tab 4) - I have created a pivot table based on the Power Query (tab 3). Now when I update the data in tab 1 & 2, the Power...

Honestly, I'm ashamed I can't figure this out. I have data that has group names in the row (subject, institute, location), then columns are numbers. I want to show the row percentage of the location but none of excel's default options are working. Instead of the % of the parent row or column...

Hello, Workbook name: Report Sheet with pivot: Summary Sheets with data source: Source1 , Source2 (data in range A1:C14) In the above workbook, I defined the name PivotChange_Source with formula =INDIRECT(Summary!$A$1&"!A1:C14") to change the Pivot source within the Workbook based on A1 input...

Hi, I have a tablet that looks like this: <DATE><DOMAIN><YES/NO> I have created a pivot with the rows DOMAIN and the columns DATE. I then have these values: the number of rows (count(something) and the number of YES (sum of all 1) It looks like this: [/URL] I would instead like to display...

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.