Daily average sales

[schappelljr]

I am trying to find what the average sales per day. Been trying to do it with a pivot table and I can’t get it to work because how the data is laid out. Does anyone have a suggestion how to do this?

Product 1= 6 units /2 days = 3 per day
Product 2 = 3 units /2 days = 1.5 per day

Date	Store	Product
9/1/2017	Store 1	1
9/1/2017	Store 1	1
9/1/2017	Store 1	1
9/2/2017	Store 2	1
9/2/2017	Store 2	1
9/4/2017	Store 1	1
9/4/2017	Store 1	1
9/5/2017	Store 1	1
9/5/2017	Store 2	1

<tbody>
</tbody>

 

[Caribeiro77]

Why did you put:
Product 1= 6 units /2 days = 3 per day
Product 2 = 3 units /2 days = 1.5 per day

Where do we see this in your table?

 

[schappelljr]

Date	Store	units
9/1/2017	Store 1	1
9/1/2017	Store 1	1
9/1/2017	Store 1	1
9/2/2017	Store 2	1
9/2/2017	Store 2	1
9/4/2017	Store 1	1
9/4/2017	Store 1	1
9/4/2017	Store 1	1
9/5/2017	Store 2	1

<tbody>
</tbody>

Opps i made an error on the table.

Store 1 sold a total of 6 units over 2 different days, three on 9/1/17 and three on 9/4/17.
Store 2 sold a total of 3 units over 2 different days on two on 9/2/17 and one on 9/5/17.