I’m trying to create the following table:
Category | Dec 2016 | 3Mo Benchmark
A | 200 | 230
B | 145 | 189
C | 235 | 300
My approach is the following -
filter: 5 months ago for 4 months.
Pivot above table by Month and got the following header:
Month | Sep | Oct | Nov | Dec | BM (table calc)
BM is equal to average of (pivot_index(events, 1) + pivot_index(events, 2) + pivot_index(events, 3) )
But I can’t hide Sep, Oct, Nov results so that only Dec and BM columns are showing.
Is there a better way to get the top table? thanks.