pivot

  1. N

    Sorting through pivot table data based on user input

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

    Pivot Calc Help

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

    Pivot VBA issue.

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

    Preventing collapsing columns while refreshing Pivot Tables

    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?
  5. E

    Pivot Table Sorting Dates Out of Order

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

    Sort pivot using VBA

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

    What do you called this? A Grouped/Aggregated field list pivot?

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

    Pivot Table Date Filters not formatting correctly

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

    Please help, to get multiple items selected in pivot table's Filter

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

    Macro not recording pivot table label filter correctly

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

    Recreate my table in pivottable

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

    Pivot Table range when new columns are added to source

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

    Re-organizing pivot table fields in vba

    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:= _...
  14. H

    Create an advanced pivot table

    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:
  15. R

    Can't insert PIVOT table after deleting worksheet with previous PIVOT table on it

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

    Printing data from pivot table

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

    Auto Refresh PivotTables & Queries not working

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

    Please help this idiot - how can I display the row percentage in a pivot?

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

    Change Pivot Data Source Based on Cell Selection

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

    Pivot table question

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top