Skip to Content
0
Former Member
Sep 11, 2014 at 12:22 PM

Restrict Running sum in Webi

70 Views

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