Filtering a graph for specific row/categories only but still retain other rows/categories?

[Anonymous]

Hi,

I would like to know how to filter a specific category from a graph but still retain the other categories. Example,

I have a bar graph for sets of brands (Laptops) and their sales for the month of May. Say that my filter is for ASUS ONLY. I want to display a graph with filter for ASUS laptop models but still retain other values from other laptop brands. I'm talking about a specific row filtering only which filters ASUS BRAND only but retains other data from the graph.

[Ashish_Mathur]

Hi,

I am not sure of what you want but refer to my solution here - Filter a column of a Pivot Table on a certain condition but also show other items from that column.

Hope this helps.