pivot

Hi everyone I've got an excel sheet with data sourced from PowerBI which is utilised daily however, I'm having to click "Refresh All" under Data every time i use it. Is there anyway to automate the data refresh? The PowerBI data is updated once every morning, if I could align my data to...

Hello everyone I have a pivot table that sorts data based on the date, the goal is to make this more user-friendly so that other people can use it. The pivot data I'm using is outsourced from PowerBI so I don't want to adjust it. Basically, the date filter for the pivot table sorts the date...

Hi All I'm trying to add a calculation field to work out the % of two items in my pivot However, when I try to insert the calc field, i'm unable to work with the columns I need to work with My data set consists of individual training records, each row consisting of an e-learning module that...

I have a pivot table created where I'm trying to copy the data from pivot table to another sheet. below is the snipper of the pivot data Sheet where im trying to move the data With the below code im only able to iterate through the first row of the data for each user and only first row for...

My Pivot Tables are refreshed automatically through loads of UNIT4 ERP. Using Excel 365. But they are automatically collapsed: I need them (automatically) expanded: How can I prevent the collapsing?

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