Hey,
I have a power pivot with over 10,000 rows of data. I have used a power pivot to group this data by product and then by materials in product. I am interested in looking at the top 20 products and the amount made over the past year in each month. I put a filter on my powerpivot table to achieve this. I created a pivot chart that mapped out the products made against month. However, I want this chart to be able to show only one product at a time.
I inserted a slicer in but the slicer has the all the products in the list (over 100).
Is there a way to set the slicer so that it only shows top 20 products to make it easier to select.
I was thinking if I could delete the non filtered data this would work but can't find that option on excel.
Thanks,
D
Bookmarks