Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
You should be able to consolidate this information within PeopleSoft itselft
using the query function. This function also has a feature to eliminate duplicates. I don't believe you need to bring the data into excel at all. " wrote: The system we are running is Poeple Soft. I know it is possible to get this done through the People Soft functionality but we are not fully implemented at this time. People Soft has a query function in which you can run the query directly into an Excel spreadsheet. So for this example I have three seperate spreadsheets with data. It is possible to run nVision reports, however as I said we are not fully impelemnted at this time. Let me know if you have any other questions and thanks for your help! Gerald |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
overlapping pivot tables | Excel Discussion (Misc queries) | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |