a Filter thing...

[Anonymous]

Hi guys and sorry in advance to bother you for this little stuff,

i have 1 single table with a measure, let's say the "price".

i calculate the average price value.

And i want to filter that table to only keep the lines where my price is above the average value.

A restaurant in Paris for the fastest helper.

(but i don't pay the flight ticket 🙂

Thanks !

[Anonymous · Accepted solution]

it works with storing the average in a calc column and then do a FILTER(Table;price<avg_calcol)

if you have a solution without calc col, i take it.

---

[Anonymous]

oh i didn't try calculated columns to place the average in. I was hoping to do it without calc col.  -:)