schappelljr
Board Regular
- Joined
- Feb 2, 2009
- Messages
- 55
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
<tbody>
</tbody>
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>