M
Marwan
I have a database with a certain number of items where each one carries its
own ID#, and its own order qty over a period of time(in Months).
I would like to create a pivot table, where I can see the average units
ordered per item.
Example if I order 100 units total, and I have 5 items, I want to see the
pivot table calculate the average whicjh is 2 in this example.
can I do it at the pivot table level, or it should be done in a spreadsheet
and brought in?
The reason I ask is that my time range is from June 08 to March 09, and the
items fall under different departments. And I would like to see what is the
average per month or per dept or a combination of these two variables.
Sorry it is complicated, any help will be great.
Thank you,
Marwan Asmar
own ID#, and its own order qty over a period of time(in Months).
I would like to create a pivot table, where I can see the average units
ordered per item.
Example if I order 100 units total, and I have 5 items, I want to see the
pivot table calculate the average whicjh is 2 in this example.
can I do it at the pivot table level, or it should be done in a spreadsheet
and brought in?
The reason I ask is that my time range is from June 08 to March 09, and the
items fall under different departments. And I would like to see what is the
average per month or per dept or a combination of these two variables.
Sorry it is complicated, any help will be great.
Thank you,
Marwan Asmar