Forum Discussion
Henrique Menezes
Apr 24, 2018Copper Contributor
Pivot table-filters
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?
- Logaraj SekarSteel Contributor
Hi,
I think you want highest value of the range.
Use MAX function for that.
Eg. "=MAX(A2:A6)"