Pivot Table Dates

[tstri]

I have a dataset that contains a list of items with a unique id, create date, and close date. How do I get a pivot table to have dates by day in the left most column, a count of records created in that day in the second column, a count of records closed in the third column, and the difference in the third.

Date. Created. Closed. Diff
1/1/2019. 150. 100. 50
1/2/2019. 100. 150. -50

 

[alansidman]

Your sample data (really need to see more data in your sample example) does not represent your explanation. I am confused as you have fields in your explanation that are not shown in your example.

 

[tstri]

Your sample data (really need to see more data in your sample example) does not represent your explanation. I am confused as you have fields in your explanation that are not shown in your example.

My apologies:

My data:

Id. Created. Closed
1. 1/1/2019. 1/3/2019
2. 1/1/2019. 1/3/2019
3. 1/1/2019. 1/1/2019
4. 1/2/2019. 1/2/2019
5. 1/2/2019. 1/5/2019
6. 1/3/2019. 1/3/2019
7. 1/3/2019. 1/5/2019
8. 1/3/2019. 1/5/2019
9. 1/3/2019. 1/5/2019
10. 1/3/2019. 1/5/2019

Desired Result:

Date. Created. Closed. Diff
1/1/2019. 3. 1. 2
1/2/2019. 2. 1. 1
1/3/2019. 5. 3. 2
1/5/2019. 0. 5. -5

 

[alansidman]

Inserting the data into a Pivot Table gets the following results. Then using simple excel subtract one value from the other for a difference

Data Range

	A​	B​	C​	D​	E​	F​	G​	H​
1​	Id​	Created​	Closed​	​	​	​	​	​
2​	1​	1/1/2019​	1/3/2019​	​	Created​	Closed​	Count of Created​	Count of Closed​
3​	2​	1/1/2019​	1/3/2019​	​	1/1/2019​	​	​	​
4​	3​	1/1/2019​	1/1/2019​	​	​	1/1/2019​	1​	1​
5​	4​	1/2/2019​	1/2/2019​	​	​	1/3/2019​	2​	2​
6​	5​	1/2/2019​	1/5/2019​	​	1/2/2019​	​	​	​
7​	6​	1/3/2019​	1/3/2019​	​	​	1/2/2019​	1​	1​
8​	7​	1/3/2019​	1/5/2019​	​	​	1/5/2019​	1​	1​
9​	8​	1/3/2019​	1/5/2019​	​	1/3/2019​	​	​	​
10​	9​	1/3/2019​	1/5/2019​	​	​	1/3/2019​	1​	1​
11​	10​	1/3/2019​	1/5/2019​	​	​	1/5/2019​	4​	4​
12​	​	​	​	​	​	​	​	​