+ Reply to Thread
Results 1 to 1 of 1

excel pivot table new data add to group in format issue

  1. #1
    Forum Contributor Jack7774's Avatar
    Join Date
    08-31-2012
    Location
    Georgia, US
    MS-Off Ver
    Excel 2010
    Posts
    576

    excel pivot table new data add to group in format issue

    Attached is two tabs, xero dump is a SQL database table with data that I've modified since its out financials to avoid disclosure issues but allow the spreadsheet experience to help solve the problem. All tab is a pivot table income statement that was 100% complete until we added two new accounts with data. The issue is these accounts instead of adding themselves near the other accounts by acsending order they are underneath the entire formatted table but still apart of the pivot table. I want to group 4001,4002, 4003, 4004, 4025, 4050, and 4005 which is on the bottom in one group that is Gross revenue located at the top. Any idea why i can't just highlight those accounts and click group like before and then all of those accounts will be at the top in a group. Instead it puts one group but lists it twice once at the top and once at the bottom. I have the same issue for account 6250 as well and I need it in the group with the 6xxx's. Any ideas what I could try?
    Attached Files Attached Files
    Thank those who have helped you by clicking the Star * below their name and please mark your post [SOLVED] if it has been answered satisfactorily.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Group data in pivot table by date
    By leobueno in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-16-2016, 12:29 PM
  2. [SOLVED] Issue with pre formatted date in pivot table (Cannot group that selection)
    By ppgab in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-25-2016, 12:22 PM
  3. Pivot table date format issue when drop down run on VBA - Excel 2003
    By NotBright in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2014, 06:28 AM
  4. [SOLVED] Can't group Data in Pivot Table
    By Fletch74 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 03-23-2014, 06:26 PM
  5. how to create group in pivot table data
    By ganeshadeshpande in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2013, 04:33 AM
  6. Why does the pivot table not allow me to group data?
    By Forrest in forum Excel General
    Replies: 6
    Last Post: 01-12-2006, 09:15 PM
  7. Excel - pivot table - how do i format cells with data mm/dd/yyyy .
    By Dave in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1