R
RobVT
Using MS Access 2003.
I have a database containing historical production data. To use this
data, the user enters a series of parameters about their current
project. These parameters are matched to database projects. From the
list of similar projects, the work items associated are returned to the
user. In the work item table, there is an entry for each work item for
each month it is used on each project.
The query for the appropriate work item data is summarized using a
pivot table. That way the user can sort by the work item first, then
the month used. For each month, I'm calculating the minimum, maximum,
and average.
What I would like to do is remove the top and bottom 10% for each set
of work items, thereby removing the absolute extremes.
Is there any way to accomplish this? I first considered using the
query to do this, however there are a large number of work items used
and I would like to keep the database set up such that work items used
may change over time. That way, the user retrieves whatever he puts in
the database originally.
I hope this wasn't too confusing, I couldn't come up with a better way
to say it.
As always, thanks in advance, I welcome all comments and thoughts!
Rob
I have a database containing historical production data. To use this
data, the user enters a series of parameters about their current
project. These parameters are matched to database projects. From the
list of similar projects, the work items associated are returned to the
user. In the work item table, there is an entry for each work item for
each month it is used on each project.
The query for the appropriate work item data is summarized using a
pivot table. That way the user can sort by the work item first, then
the month used. For each month, I'm calculating the minimum, maximum,
and average.
What I would like to do is remove the top and bottom 10% for each set
of work items, thereby removing the absolute extremes.
Is there any way to accomplish this? I first considered using the
query to do this, however there are a large number of work items used
and I would like to keep the database set up such that work items used
may change over time. That way, the user retrieves whatever he puts in
the database originally.
I hope this wasn't too confusing, I couldn't come up with a better way
to say it.
As always, thanks in advance, I welcome all comments and thoughts!
Rob