I had posted this before and I know it may be a challenging one, but I
am wondering if anyone might know how to do this:

Is there a way to program advanced formulas into an excel pivot table.
For example, if you have created a pivot table and it has a drop down
menu for age groupings from which users can select from a wide range of
age groupings, for example:

age 1-5
age 5-10
age 15-20
age 20-25

Is there a way to program the pivot table to do the following:

1) identify if the "standard set" of age groupings: age 5-10, age
15-20, age 25-25 are in the selection in the drop down list
2) if the all the "standard set" age groupings are there, aggregate
them all to make one age grouping "age 5-25"
3) add this new calculated age grouping to the pivot table and the list
in the drop down list for age groupings (but only if all of the age
groupings are there).
4) if all the the "standard set" age groupings are not there to do an
aggregation, then do nothing for that age grouping aggregation.

Looking forward to your suggestions.

Marina Madeleine

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!