Thanks, I cannot use StoreId in rows, because our StoreID has 400 set.
Our Demo data includes demo date, demo storeID, How many case we sold at
this store per day/month, we have 1600 records, so I use Pivot table to get
some data we need.
but now I want get this particular field : [(sum of sold / count of store)
per week]. so I will know per week how many case we sold at each store.

"Fred Smith" wrote:

How does Sum of SoldQty / Count of StoreID get you number of cases sold by
store? Doesn't Sum of SoldQty get you number of cases the store sold? Don't you
just want a pivot table with StoreID as a row field and SoldQty as a data field?

--
Regards,
Fred


"???" wrote in message
...
Thanks, But A & B is different field. for example, A is soldQty and B is
StoreID. so I need Summary of SoldQty / Count of StoreID. If I get this data
I will know how many case we sold by per store and per time.

"Fred Smith" wrote:

Why isn't the count of A the same as the count of B? If so, just show the
Average of A. If not, I think you need to add a separate column to your
database.

--
Regards,
Fred


"???" wrote in message
...
Hi.
I have a question need help..
On Pivot table, I have 2 row(A,B), how to get result from Sum of A / Count
of B?