| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
show duplicate rows in a pivot table using vba
I have created a pivot table using VBA and am now trying to make it sho duplicate rows for me. THe pivot table shows jobs. If there are tw jobs with the same title, i still want both jobs to show b/c they ar unique to me. How can i get this to work in my pivot table?? -- ktpac ----------------------------------------------------------------------- ktpack's Profile: http://www.excelforum.com/member.php...fo&userid=1216 View this thread: http://www.excelforum.com/showthread.php?threadid=38758 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
show duplicate rows in a pivot table using vba
You need something in the job title to make them unique. Or add another
field, like job number, that will differentiate them. ktpack wrote: I have created a pivot table using VBA and am now trying to make it show duplicate rows for me. THe pivot table shows jobs. If there are two jobs with the same title, i still want both jobs to show b/c they are unique to me. How can i get this to work in my pivot table??? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
show duplicate rows in a pivot table using vba
I do have a requisition number that is unique for each one. I guess I' just not sure how to make the req number the field that the pivot tabl is looking at for uniqueness instead of the Job Title -- ktpac ----------------------------------------------------------------------- ktpack's Profile: http://www.excelforum.com/member.php...fo&userid=1216 View this thread: http://www.excelforum.com/showthread.php?threadid=38758 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
show duplicate rows in a pivot table using vba
any thoughts on how to make the requisition number the field that the pivot table looks for unique values in? I tried making it the first field in the table, but it didn't seem to care about that. -- ktpack ------------------------------------------------------------------------ ktpack's Profile: http://www.excelforum.com/member.php...o&userid=12167 View this thread: http://www.excelforum.com/showthread...hreadid=387581 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
show duplicate rows in a pivot table using vba
If job title is in the row area, put requisition number in the row area too.
ktpack wrote: any thoughts on how to make the requisition number the field that the pivot table looks for unique values in? I tried making it the first field in the table, but it didn't seem to care about that. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table excel 2007 -- show rows with no data | Excel Discussion (Misc queries) | |||
| Show only rows with duplicate values in a column? | Excel Discussion (Misc queries) | |||
| Show only rows with duplicate values in a column? | Excel Discussion (Misc queries) | |||
| Pivot table -duplicate rows | Excel Discussion (Misc queries) | |||
| Do not show rows with no values in Pivot Table | Excel Discussion (Misc queries) | |||
![ktpack[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
