Hello Looker community,
if I want to calculate a Mean of total across the whole row, EXCEPT the last column (80 or Above), what should I do?
Mean (pivot_row(products Count)…???)
Solved! Go to Solution.
Another way is to use row’s total - pivot_where(${users.age} = “80”)