Forum Discussion

Henrique Menezes's avatar
Henrique Menezes
Copper Contributor
Apr 24, 2018

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 Sekar's avatar
    Logaraj Sekar
    Steel Contributor

    Hi,

     

    I think you want highest value of the range.

     

    Use MAX function for that.

     

    Eg. "=MAX(A2:A6)"

Resources