Pivot table-filters

[Henrique Menezes]

Good afternoon,

Is it possible to bind the filter from a PivotTable to a cell?

For example:

I would like to see in my PivotTable only the stores that have Criterion A above my Upper limit cell. It's possible?

[#2]

Hi,

I think you want highest value of the range.

Use MAX function for that.

Eg. "=MAX(A2:A6)"