Results 1 to 10 of 10

PowerPivot Tables

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-22-2011
    Location
    Texas, United States
    MS-Off Ver
    Excel 2007 and 2010
    Posts
    516

    PowerPivot Tables

    I have a table called 'Car', in it i have a column called PolicyLink. the PolicyLink column contains numbers such as 445577, 445578, 445579, 445579, 445579. I am trying to associate how many cars are on a policy and what number that car will be given on the policy so I have a PolicyLink number and if it repeated more than once then the numbers will go in sequencial fasion until there is a new policy.



    PolicyLink --------------------- Car Number

    445577 --------------------- 1

    445578 -------------------- 1

    445579 --------------------- 1

    445579 --------------------- 2

    445579 --------------------- 3

    here i have 3 policies so i have the first policy having one car, second having one car, and the third having three cars and so on and so forth. I am looking for a formula to insert into a new column in PowerPivot called 'car number'. the number under PolicyLink is PolicyLink and the -- just represent a change in column, so there is a column called 'car number' with single digits in it. Any help is appretiated
    Last edited by amotto11; 08-24-2011 at 08:30 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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