Ignore first row value from filter

Tags: #<Tag:0x00007efc65765d28>
#1

Hello

I created a totals row as the first row in my table and I succeeded calculating it and updating it’s value when data get’s changed/inserted/removed. Now I would like to ignore in the filter menu, on the filter
by value section, the value from this first row, for the filters of each column.

Is there a way to achieve that?
Thank you in advance for your help!

#2

Hi @marius.comiati

the filter_by_value is not adjustable. It is a list of all the values for a single column.

You have two possible options

  • create a table with a single row to show the summaries in that row (it won’t be visible in the filtering list)
  • you can block the operation when someone what’s to filter out the summary
#3