Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm trying to create a Pivot table showing the cumulative percentage of the 'base', like the pivot in green below. Any ideas?
Use the following as the measure:
rangesum(above(total sum(Orders), 0, rowno(Total))) / sum(Total Orders)
Hope it helps!