Calculate Cummulative Percentage of amount over date range column

Question & Answer
,
1

Hi,
I am trying to display cumulative percentage of my amount field basis a date range column.
I would like to show something like this -

image
image764×626 35.8 KB

So far, I have tried creating a rank column to sort my date range and tried to do running sum basis the rank column.
runningSum(amount, rank asc) but this is not giving me correct value. Since this is a calculative field, I am not able to do percent of total to get percentage.

runningSum()/sumover() did not work for me.

2

@sakshisl what’s the raw data look like? what’s the source of the data?

3

Hi All,
I was able to calculate the cummulative percentage so will be closing this Question.
However, for future references:
you need to do,
runningSum(amount, rank asc)/sumOver(amount,)

sumOver(amount,): empty will make sure you get sum at an overall level and this will be giving correct percentage.