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?

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?

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?

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?

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?

I'm still lost.

Do you want the results to be in the Pivot Table, or are you calculating these
results separately from the Pivot Table (ie, via a formula)?

When you say Count of storeid, what does Column B look like? Is it a list of
storeids where the storeid is unique, or can the storeid appear more than once?
Do you want a count of the number of times that a storeid appears in Column B?

--
Regards,
Fred


"???" wrote in message
...
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?

Thanks, Let me explain the detail.
I used SQL like
select ShipQty, CustID, Shipdate, null as StoreID from SO
union all
select null as Shipqty, CustID, DemoDate, StoreID From Demo.
So I have 4 field import to pivot table. now I want get a result is
sum of Shipqty / count of StoreID. do you think that posible to get data
that's I need?


"Fred Smith" wrote:

I'm still lost.

Do you want the results to be in the Pivot Table, or are you calculating these
results separately from the Pivot Table (ie, via a formula)?

When you say Count of storeid, what does Column B look like? Is it a list of
storeids where the storeid is unique, or can the storeid appear more than once?
Do you want a count of the number of times that a storeid appears in Column B?

--
Regards,
Fred


"???" wrote in message
...
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?