On 2002-05-13 06:54, Mark W. wrote:
Use AutoFilter
Please excuse me, I'm afraid I did not make it clear. AutoFilter is no help (and BTW - I think I tried all the obvious things - I am quite experienced - but surprise me, please.)
Let me try a larger problem description:
I need to track SW versions with K features (typically divided into groups and sub-groups) and implemented on X platforms. for each combination Feature/Platform I have a value that can be the date of release, or "is it required/commited/for whom" etc. etc.
We are talking ~250 Features on ~20 Platforms.
Now an Excel DB can record all this as a table but is very hard to "get the big picture" from. AutoFilter can answer a specific query, BUT, The result is still a table, and moreover, most of the values are the same in many columns, which makes it hard to see where changes occur.
(e.g. "show featuers for Release X, on all platforms, for all customers" query, will get me a table with same customer-value for all relevant features (say 100 lines) and then the next group of lines will show the next customer, for the next group of features, etc ...)
So, I want the "total by categories" feature, as in a Pivot table, which also allows the user (or at least me) to easily generate different views of the DB.
I created such a Pivot table, but the data is "count of" values, and I use it as a quick way to generate the datable entires relevant to each cateogry-value combination.
This is really (I think) a tough one ...
Michael Orr
_________________
Michael Orr
This message was edited by orr on 2002-05-13 08:44