hi,
I have two columns. one with items sold, second with dates in which these items were sold. many of the sells in both columns are identical. I need to get a formula that counts a dividing result of total sales number per number of weeks.
for example:
NAME WEEK NUMBER
ITEM 1----------------2
ITEM 2----------------2
ITEM 1----------------3
ITEM 3----------------2
ITEM 2----------------2
RESULT:
ITEM 1 = 1
ITEM 2 = 2
ITEM 3 = 1
Last edited by afgi; 07-02-2011 at 05:11 PM.
so you have 1 column, which lists sales; such as
Column 1
16 " pipe
hammer
wrench
mallet
Column 2 (sold on)
6/5/11
6/5/11
6/6/11
6/7/11
Is this correct?
and you want to know how many total sales you have made, per business week?
hi, not exactly. The outcome which I need to get is to find the item that has the highest average sale in a specific time range.
For example: I sold 5 items of Product 1 in time range of 2 weeks; and 5 items of Product 2 in time ranege of 1 week. the Product 2 is the item I would need to focus on.
result I would like to get is as below:
- Product 1 = 2,5 (number of items / number of weeks)
- Product 2 = 5 (ditto)
the highest result, the better... the problem I face, is that I sell hundreds of items and products per day and I need to find a method to get this final result in a pivot table
many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks