Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
francisvandergr
Partner - Creator II
Partner - Creator II

Avg of the last three years in Pivot table

I have 3 dimensions in my pivot table

Afther my last year i would like to have an avg over the last three years. Is this possible?

I included an example

1 Reply
sgrice
Partner - Creator II
Partner - Creator II

just do it with RangeSum

i.e.

rangesum(above(count(x),0,3))