Short Version:
While doing the line chart base off of Pivot Table with % based on row total. I noticed when hiding the products that don’t need my attentions, the other products’ % value changed. This is not what I want. I want to retain the product’s % value as I hide or filter other products...