Is there a way to create a pivot chart that will only show the selected results based upon other criteria that I don't want displayed on the chart? For example I have a list of customers where I only want to display the gross margin % for the top 20 customers based upon revenue. However, I don't want the revenue to be part of the chart - just the margin.
Thanks.
Thanks.