How to include "greater than" "equal to" conditions in pivot charts?

[sujay36]

Hi,

I have data set containing
1. Retailer name
2. Brand or manufacturer
3. Product name
4. Weight of product
5. Price per 100 grams

Depending on certain conditions of weight of product and price of product (Report Filter), I have created a pivot table containing retailer name, brand or manufacturer and product name in Row Tables, count of product names in "Values". Now to change conditions, I have to manually select data points in Weight of product and Price per 100 grams tabs. Is there any way I can put direct conditions of "greater than" or "equal to" which pivot table will readily acknowledge and make changes?

 

[Luke M]

Hi, and welcome to the forum!

Just need to move those two fields to be a Row field. Then you can easily filter as desired. See attached.

 

[sujay36]

Hey Luke M thank you!

 

[sujay36]

Hey Luke M I have added both columns to row field, but it does not give me filter option. How do you add label filters to these columns also?

 

[Luke M]

Did you add them into the Row Field area like in my example? You should be able to do a label filter.