Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. Templates and Calculators The Way of the Weasel Download Ivan & Colo's HTML Maker Here 101 Excel Hacks - Great New Book Huge Savings on Excel Training February 11th, 2004 #3 Change the grouping of the second pivot table. My AccountSearchMapsYouTubePlayNewsGmailDriveCalendarGoogle+TranslatePhotosMoreShoppingWalletFinanceDocsBooksBloggerContactsHangoutsEven more from GoogleSign inHidden fieldsSearch for groups or messages ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: http://0.0.0.8/ have a peek here
I get an error "Cannot group that selection". Then base the pivot table on this new column and uncheck the bogus date field. This lets you quickly see subtotals for a specific set of items in your pivot table. You can now refresh the pivot and should be able to group. http://www.ozgrid.com/Excel/grouping-pivot-tables.htm
Will not even give me the option to choose month, year,etc. >>>> -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com Debra Dalgleish, Jan 17, 2010 #6 Doug Muegge Guest I am This, depending on how many extra rows you include, can end up increasing your file size by 100% or greater. In the Pivot Table “Start Date” is a Column Field. Start Date is also used as the data field (Count of Start Date).
I took out > > > > all blanks. Sign Up Now! asked 4 years ago viewed 7411 times active 4 years ago Related 1Excel pivot table group all months by year2Dates not recognized as dates in pivot table pulling directly from SQL Pivot Table Grouping Not Working I did not have any empty spaces and all of my dates were formatted properly.
This column contains only dates. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 10th, 2004,06:28 PM #4 Juan Pablo González MrExcel MVP Join Date Feb 2002 Location Bogota, Colombia Posts 11,959 Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search Or, add new fields in the source data, to calculate the year and year/month, for each date, and use the new fields in the pivot table, instead of grouping.
For example, group order dates by year and month, or group test scores in bands of 10. Cannot Group That Selection Pivot Table 2013 TJ wrote: > Hi, > > I'm having the same error :-( > > I have tried the things suggestion in this trail but still am getting no > where. > Results 1 to 4 of 4 Thread: [Solved] Pivot Tables : “Cannot Group That Selection” error Thread Tools Show Printable Version Search Thread Advanced Search February 11th, 2004 #1 steveski I have checked > > for blank rows as suggested in this thread.
If you're having a computer problem, ask on our forum for advice. http://kelcours.com/pivot-table/excel-pivot-table-cannot-group-that-selection.html Any advice for getting the pivot table to ignore the blanks? Date2. Cannot Group that SelectionThe first problem "Cannot Group that Selection" is normally caused by one of two things. Pivot Table Not Grouping Dates
April 12th - 18th: Free webinar, Mastering Pivot Tables -- Learn how to set up data and create a Pivot Table in less than 3 minutes. Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. This worked for me! Check This Out Originally It did not due to data > in row 2000.
In the popup menu, click Group In the Grouping dialog box, enter 1 in the Starting At box In this example, the highest number of units is 50, and you can Group Dates In Pivot Table Excel 2013 Show key business metrics, and much more. Perhaps we'll spot an issue. *********** Regards, Ron XL2003, WinXP "Marion" wrote: > I am working in a pivot table, dragged my dates in from source data and want > to
The whole column should be converted to numbers. For 'Number of days', select 7 The week range is determined by the date in the 'Starting at' box, so adjust this if necessary. Member Login Remember Me Forgot your password? Excel Pivot Group By Month And Year Then I brought in a column of dates from the ‘real’ data entry sheet, and now the grouping is not functional (“Cannot Group That Selection” error).
Why did Borden do that to his wife in The Prestige? Download the sample file for the extra items in date grouping. A guy scammed me, but he gave me a bank account number & routing number. this contact form More About Us...
Ozgrid Retains the Rights to ALL Posts and Threads Register Help Remember Me? Because you created the two pivot tables from the same source data, by default they use the same pivot cache, the grouped items are the same in both tables. Just be sure to select dummy data that cannot be misinterpreted for actual data. Then, add the field to the data area of the Excel pivot table.
To start viewing messages, select the forum that you want to visit from the selection below. Learn how to group items, and avoid problems. The range includes all cells I expected. Download the sample file for the extra items in date grouping.
How did you check the format of the dates? Grouping Dates by Week To group the items in a Date field by week Right-click on one of the dates in the pivot table. If there is text in the date/number field, remove it. Perhaps we'll spot an issue. > > > > > > *********** > > Regards, > > Ron > > > > XL2003, WinXP > > > > > > "Marion"
Not sure what to do > next. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com Debra Dalgleish, Jan 24, 2010 #10 Advertisements Show Ignored Content Want to reply to this thread This feature isn't available in a normal Excel pivot table (see the workaround in the next section). Not sure what to do next. -- Doug M "Debra Dalgleish" wrote: > There are a few other suggestions for fixing grouping problems here: > > http://www.contextures.com/xlPivot07.html > > > Doug Instead, you can manually group the items.
I checked the formats of the data by Format=>>Cell=> Date. Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. The time now is 06:22 PM.
© Copyright 2017 kelcours.com. All rights reserved.