How to get data from PT
 

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 to get data from PT
 

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 to get data from PT
 

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 to get data from PT
 

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?

How to get data from PT
 

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?

How to get data from PT
 

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?

How to get data from PT
 

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?