Pivot Tables & Custom Lists

[GarethG]

I am running some pretty complex pivot tables based on an Access
Database using MS Query to build relationships between vairous tables.
However, because my company loves to make things as complicated as
possible for me, I have to exclude a particular set of information from
auto-generated reports. I have a list as such:
AAA
BBB
CCC
DDD
EEE
FFF
ZZZ

I need to summarise data based on other fields such as Months and
product groups, but I want it to exclude i.e. customer type ZZZ so that
it efectively does the opposite of having a set of pivot pages. (Pivot
Page allows you to view one particular group or ALL, I want it to show
all but this (ZZZ). I cannot have the customer types displayed on the
same report, because it makes it monstrously large and it does not
total how I require.
Any suggestions as to how I could perhaps build a custom version of my
list without having to mangle the original data in my database?

GarethG
Live The Dream



------------------------------------------------


-- View and post Excel related usenet messages directly from http://www.ExcelForum.com
at http://www.ExcelTip.com/
------------------------------------------------

 

[Debra Dalgleish]

1. Add CustomerType to the Page area.
2. Double-click the CustomerType field button
3. From the Hide list, select ZZZ
4. Click OK

Or, in MS Query, set the criteria for CustomerType to: <>"ZZZ"