Hi,

I have created a pivot table for Top 10 selling products by Product Category. The row fields are Product Category & Product Code. The data field used is Sales. The pivot is also filtered (Page field) by Geography.

I want to use this data in a separate static table which would pick data from the pivot table and show in this table. The issue i am facing is that if I reference the cells, for some of the product categories, the products which are shown in pivot table might be less than 10. This changes the position of the cell for next product category.

Can someone suggest an alternative for achieving this?

Thanks a lot in advance.