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 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 to only list those products belonging to
the selected category in the ‘filter’ field instead of all the
products as it currently does.