looker pivot subtract previous number in same row

Tomer Zeituni answered on April 30, 2023 Popularity 2/10 Helpfulness 1/10

answer looker pivot subtract previous number in same row

Comment

-1

the opposite of cumsum in looker

pivot_index(${aircraft.count},1)*2-sum(pivot_offset_list(${aircraft.count},1-pivot_column(),pivot_column()))

if I have an initial cumulated sum and I would like to subtract each subsequent value as the row goes.

Popularity 2/10 Helpfulness 1/10 Language whatever

Tags: looker pivot row whatever

Link to this answer
Share Copy Link

Contributed on Apr 30 2023

Tomer Zeituni

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.