hi Excel Folks
please see attached the example spreadsheet for two basic project management sheets with raw data in Sheet 1 and Pivot Table in Sheet 2.
I would like to see projects detail per each PM, so I have used a Pivot Table to generate that view as well as summarised budget and cost at left, but then I want to see the other project details at right. but for all fields in the Pivot Table, Excel must choose a way to summarise them even for fields not applicable in logic, such as description, start date, close date etc.
currently for illustration purpose, I manually put the column names at right and they are not
part of the Pivot Table.
how can I generate a single table containing all the info (views) i need?