Frank Bacchus
Member
Hi All:
I have a data sheet containing issues which are (1) recently added, (2) recently closed, (3) still opened and (4) Closed. I would like to create a pivot table with three row: (1) “Currently Opened Issue” - items (all issue currently flagged as “Open” in the “Status” field (2) All “Closed Last Week” items (all issues closed in the last week, with the “Modified Date” between 9/12 – 9/16, and flagged as “Closed” in the “Status” field) and (3) “Added Last Week” items (all issues added in the last week, with the “Modified Date” between 9/12 – 9/16, currently flagged as “Open” or “Closed” in the “Status” field):
So my rows would look like this:
Currently Opened Issue: 16
Closed Last Week: 27
Added Last Week: 32
Sample attached. Thanks in advance.
frank
I have a data sheet containing issues which are (1) recently added, (2) recently closed, (3) still opened and (4) Closed. I would like to create a pivot table with three row: (1) “Currently Opened Issue” - items (all issue currently flagged as “Open” in the “Status” field (2) All “Closed Last Week” items (all issues closed in the last week, with the “Modified Date” between 9/12 – 9/16, and flagged as “Closed” in the “Status” field) and (3) “Added Last Week” items (all issues added in the last week, with the “Modified Date” between 9/12 – 9/16, currently flagged as “Open” or “Closed” in the “Status” field):
So my rows would look like this:
Currently Opened Issue: 16
Closed Last Week: 27
Added Last Week: 32
Sample attached. Thanks in advance.
frank