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


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Store[/TD]
[TD]Product[/TD]
[/TR]
[TR]
[TD]9/1/2017[/TD]
[TD]Store 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/1/2017[/TD]
[TD]Store 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/1/2017[/TD]
[TD]Store 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/2/2017[/TD]
[TD]Store 2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/2/2017[/TD]
[TD]Store 2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/4/2017[/TD]
[TD]Store 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/4/2017[/TD]
[TD]Store 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/5/2017[/TD]
[TD]Store 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/5/2017[/TD]
[TD]Store 2[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[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]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Store[/TD]
[TD]units[/TD]
[/TR]
[TR]
[TD]9/1/2017[/TD]
[TD]Store 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/1/2017[/TD]
[TD]Store 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/1/2017[/TD]
[TD]Store 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/2/2017[/TD]
[TD]Store 2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/2/2017[/TD]
[TD]Store 2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/4/2017[/TD]
[TD]Store 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/4/2017[/TD]
[TD]Store 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/4/2017[/TD]
[TD]Store 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]9/5/2017[/TD]
[TD]Store 2[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

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.