Combining of non-specified items into single group in Pivot chart

[JackAtArcLight]

Hi All:

I have a table that captures different types of Investments with 3
categories: Operating, Construction, Development.

I need to create a pivot chart showing the percentage of development
investments to all others. I am able to create a chart that gives a
percentage for each of the categories. I would just like to have a
development/NonDevelopment chart. Is there a way to group, or rather, how
would I accomplish this?

Thanks in advance for the help.

 

[PieterLinden via AccessMonster.com]

Hi All:

I have a table that captures different types of Investments with 3
categories: Operating, Construction, Development.

I need to create a pivot chart showing the percentage of development
investments to all others. I am able to create a chart that gives a
percentage for each of the categories. I would just like to have a
development/NonDevelopment chart. Is there a way to group, or rather, how
would I accomplish this?

Thanks in advance for the help.

Jack,
the way I have solved this problem is to create a query that does the re-
categorization.

SELECT Investment, IIF([Category] NOT IN ("Operating", "Construction",
"Development"), "Other",[Category]), Quantity...
FROM src...

Then base your summary on this query, and you'll end up with 4 categories. O,
C, D, and Other.