S
Silena K-K
Hi there
I have a worksheet which contains a list of the products we analyse each
month and columns for the date the product was submitted for testing and the
date the product was released from testing. I also have a cycle time column
which is the number of days it took for the product to be released from the
date it was submitted.
I have created a pivot table from this data so I can look at individual (or
groups) products to see how many were released each month (count of release
month) and what the average cycle time for the testing was each month.
What I need now is to calculate the average cycle time per product per month
to use as a baseline however when I add a calculated field to the pivot table
and create the formula "average cycle time"/"count release month" I get
incorrect figures.
For example, "average cycle time" = 8 days "count release month" = 4
products which should give me average cycle time / product of 2 days - I get
something like 0.004.
Can someone tell me what I might be doing wrong or whether it's possible to
do this calculation in a pivot table?
Thank you, Silena
I have a worksheet which contains a list of the products we analyse each
month and columns for the date the product was submitted for testing and the
date the product was released from testing. I also have a cycle time column
which is the number of days it took for the product to be released from the
date it was submitted.
I have created a pivot table from this data so I can look at individual (or
groups) products to see how many were released each month (count of release
month) and what the average cycle time for the testing was each month.
What I need now is to calculate the average cycle time per product per month
to use as a baseline however when I add a calculated field to the pivot table
and create the formula "average cycle time"/"count release month" I get
incorrect figures.
For example, "average cycle time" = 8 days "count release month" = 4
products which should give me average cycle time / product of 2 days - I get
something like 0.004.
Can someone tell me what I might be doing wrong or whether it's possible to
do this calculation in a pivot table?
Thank you, Silena