Hi all,

I can recreate the workbook with dummy data if need be, but I would like to see if I can resolve it without having to:

Here is the issue, I have a pivot table displaying the top 100 customers by revenue. Those customers bought a wide variety of products, but I only want the top 10 showing for each customer. I have the net revenue in the Value section. So I have Customer and Products both in my row, filtered by a value filter by revenue; top 100 and top 10, respectively. That's all fine.


What I am trying to accomplish is to have a pivot pie chart that shows the distribution of the top 10 products for my top 100 customers. This is where I run into a roadblock. I can certainly value filter to show Top 10 products through the Axis section, and they do and I want them to show up on the graph. I am having a difficult time filtering those products, to make sure they show only for the top 100 customers. If I try to value filter them through the Axis section, they all show up on the pie chart, and of course that's not feasible.

In other words, I want a way to value filter two fields for my chart, but only have one of those fields show up on the chart itself. From a hierarchal point of view, I first want to value filter the data that I would be working with for the chart (Top 100 Customer), and then value filter the data that actually goes on the chart (Top 10 Products).

Please ask for clarification of my problem if you need it.

-Thank you