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...
Logaraj Sekar
Apr 25, 2018Steel Contributor
Hi,
I think you want highest value of the range.
Use MAX function for that.
Eg. "=MAX(A2:A6)"