Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have a pivot table thats dimension = area, column = week and my measure =
count(distinct [NeededID]) - count(distinct [%RequestID])
this gives me my weekly difference per area.
i need another pivot table that now shows me the Cumulative total.
so it takes the current week total(the above measure) and adds the previous Cumulative weeks total = Cumulative weekly total.
is this possible? do i need to use the peek function somehow?
Hi
Try like below
rangesum(above(urexpression, 0, rowno(Total)))
or
rangesum(above(total urexpression, 0, rowno(Total)))