on 09-11-2014 1:22 PM
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
Try Below Formula
=If Not(IsNull([Value])) Then Runningsum(Deliveries)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.