Restrict Running sum in Webi

[Former Member]

Hallo Experts,

I have following requirement. I am creating a webi report on BEx query which customer exits for YTD Calculation and Structure for Month

I need to show the data like this when User Selects JUN 20XX for the prompt.

Month	Deliveries	RunningSum
JAN	1	1
FEB	2	3
MAR	3	6
APR	4	10
MAY	5	15
JUN	6	21
JUL
AUG
SEP
OCT
NOV
DEC

But when I use =Runningsum(Deliveries)  I am getting following result

Month	Deliveries	RunningSum
JAN	1	1
FEB	2	3
MAR	3	6
APR	4	10
MAY	5	15
JUN	6	21
JUL		21
AUG		21
SEP		21
OCT		21
NOV		21
DEC		21

Can anyone suggest me solution or work around to restrict the values for RunningSum only for the values visible.

THanks

Indra

[former_member190895 · Accepted solution]

Try Below Formula

=If  Not(IsNull([Value])) Then Runningsum(Deliveries)

[Former Member]

Hi,

Please try using =Runningsum(Deliveries) in (month).

Please refer to the link below for more information on running sum:

Running Total Table Calculations | Tableau Software

See the 'running along' config..

Regards,

Ashvin