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?

 

[Fred Smith]

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.

 

[é‡é–‹æœº]

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]

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?

 

[é‡é–‹æœº]

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]

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

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.

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?

 

[é‡é–‹æœº]

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?

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

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.

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


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.

:

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


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?