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

Cumulative percentage of total

Hi, I'm trying to create a Pivot table showing the cumulative percentage of the 'base', like the pivot in green below. Any ideas?

Capture.PNG

 

Labels (4)
1 Reply
TimvB
Creator II
Creator II

Use the following as the measure:

rangesum(above(total sum(Orders), 0, rowno(Total))) / sum(Total Orders)

Hope it helps!