group by date pivot table

  1. V

    VBA: Group Pivot Dates By Year

    Hi All I am hoping someone can help I'm trying to group a pivot table by year & month in my workbook, but getting the following error: 'Runtime error 1004 - Group method of range class failed' I tried to follow the same principle as this MrExcel video, as I don't want to have to select or...
  2. G

    Excel VBA - Grouping Dates

    I have a very large spreadsheet of data with dates (confirmed that they are proper dates to Excel as opposed to strings) that I am trying to group via VBA. When I run the code, I get an error. With ptTable ' Set the row fields .PivotFields("REALDATE").Orientation =...
  3. A

    Pivot Table - ungroup similar items

    I would like to ungroup similar items in the pivot table that is grouped by default, for example, I have in an invoice column on a worksheet 2 x the same invoice number (12345) the pivot table row will recognize it once, how can I change that and pivot table should list that twice? Thanks In...
  4. B

    How to change labels on chart generated from a pivot table

    Hello, I'm really new to pivot table, and already a bit frustrated. Here's a screen grab of some sample data I'm working with. The pivot table dates are created by a basic Group By (Day=7), and appear to be a texted based cell. I don't care much about the display of the pivot table, but I...
  5. A

    Group by Months in a Pivot Table

    Hi All, Below is code that will copy data from a CSV file called "Data Export" into an Excel file called "Report Template.xlsm". This works fine, the problem I'm having is that I've created a couple of pivot tables, based on this data, and it is group by month and years in the pivot tables...
  6. U

    Cannot change one pivot table without affecting the others

    My data is not that large, about 1000 rows but I want to look at it in different ways. One pivot tables shows the average auction price for each hour. One pivot tables shows the average auction price for each month. I have several more but you get the idea. The problem is that when I group...
  7. B

    Grouping by Date in a Pivot table from Multiple Consolidation

    Hi All, I have used multiple consolidation ranges from 4 tabs to 1 pivot table that have data pulling from 4 connections. From this Multiple consolidation ranges pivot table I am trying to group a date column however when I try to do this it will not give me the option to select Days, years...

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