+ Reply to Thread
Results 1 to 2 of 2

Pivot Table- Increment Row Numbers On New Row Add

  1. #1
    Registered User
    Join Date
    11-11-2016
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    1

    Unhappy Pivot Table- Increment Row Numbers On New Row Add

    Hi all,

    I have a pivot table that is connected to a database via odbc and I have vb auto-updating the pivot table and saving the file as a new format each day. The new data is inserted as either new rows at the end of the table or inside the pivot table. Each row must have a unique id that I would like to look like where it says SIN:
    Capture.PNG

    I'm currently using the =ROW() formula to do this but when the pivot table updates and adds rows, the numbers do not increment because the =ROW() function does not carry to the new rows. Preferably, I'd like to have the string SINxxxx in the SIN column where, xxxx is the unique number ID. If I put =ROW() in the pivot table as a calculated field, the new rows will update with a number but every row is equal to 1 which isn't right. I can't edit the database I am connected to and I've tried to modify the file after saving it into another sheet/excel book but my save method just overwrites my changes every night with new data and therefore doesn't keep the formatting.

    Anyone have any idea how to increment numbers on new row insertion in a pivot table? Thanks!

  2. #2
    Registered User
    Join Date
    11-17-2016
    Location
    Istanbul
    MS-Off Ver
    2010
    Posts
    30

    Re: Pivot Table- Increment Row Numbers On New Row Add

    Maybe this helps: Instead of selecting a specific area for the pivot, you can select the whole sheet as data. This will show you empty rows, which you can disable from the report filter (uncheck "blank").

    Even when you add data to the sheet, the pivot table will cover that when refreshing.

+ 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. Counting like numbers as 1 in a pivot table
    By BadKornFlake in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-16-2015, 10:59 AM
  2. [SOLVED] Pivot Table - negative numbers
    By westsider in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-30-2014, 12:40 PM
  3. How to add serial numbers in pivot table.
    By Ejaz Qureshi in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-28-2014, 12:14 AM
  4. Pivot Table with Data instead of numbers
    By BugmanGB in forum Excel General
    Replies: 2
    Last Post: 05-19-2014, 01:33 PM
  5. [SOLVED] Pivot Table Strange Numbers
    By techteam in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-06-2012, 09:12 AM
  6. Excel 2007 : Pivot Table Grouping Numbers
    By vasik in forum Excel General
    Replies: 0
    Last Post: 09-02-2010, 11:43 AM
  7. Hide numbers in Pivot table
    By vikfowler in forum Excel General
    Replies: 6
    Last Post: 03-16-2007, 05:35 AM

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