Forum

project event track...
 
Notifications
Clear all

project event tracker

2 Posts
2 Users
0 Reactions
148 Views
(@alnomo)
Posts: 1
New Member
Topic starter
 

I'm handling multiple items on multiple projects, I want to enter data as "date", "Project", Item", "Description", "Action Req'd"

I want a pivot table on sheet 1 for project 1  (easy - filter by project)

Then item by date (easy. rows "item", "Date" )

This is where I loose it -- on the same row as the date, I want the "description" then in the next column of the same row I want the "Action Req'd"

Data table:

  11/16    proj 1   item 1    rec'v approval drawings

   11/29   proj 1    item 1   ordered hardware

   11/29   proj 2   item 10   delivered final drawings

PIVOT TABLE

   PROJECT   Proj 1

   Item 1   11/16           rec'v approval drawings

                11/29           Ordered hardware

Any ideas?

 
Posted : 30/11/2018 10:39 pm
(@debaser)
Posts: 836
Member Moderator
 

What exactly is the issue? If it's just getting them on the same row, set the pivot table layout to tabular.

 
Posted : 01/12/2018 3:32 am
Share: