D
Duck
I have a database which is basically modeled after the NorthWind
sample database provided by Microsoft. In my database I have
constructed a PivotChart depicting monthly product sales. The charts
‘series’ field holds the actual products and the ‘filter’ field holds
the categories to which the fields belong. The filter works fine as
far as the totals is concerned, but I would like for the displayed
products in the ‘series’ area pull down list, to only list those
products belonging to the selected category in the ‘filter’ field
instead of all the products as it currently does.
sample database provided by Microsoft. In my database I have
constructed a PivotChart depicting monthly product sales. The charts
‘series’ field holds the actual products and the ‘filter’ field holds
the categories to which the fields belong. The filter works fine as
far as the totals is concerned, but I would like for the displayed
products in the ‘series’ area pull down list, to only list those
products belonging to the selected category in the ‘filter’ field
instead of all the products as it currently does.