How to exclude a specific pivoted column from table calculation?

KukHwa
New Member

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)…???)

Aggregating_across_rows__row_totals__in_table_calculations__3.36__.3.png

Solved Solved
0 6 2,011
1 ACCEPTED SOLUTION

Another way is to use row’s total - pivot_where(${users.age} = “80”)

View solution in original post

6 REPLIES 6