Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Not getting cumulative count

Hello all,

I am trying to calculate running total for counts of companies.

 

I have created a matrix that is showing me the company names on rows and their count bucket on the columns.

Issue:
I am getting the cummulative values when there is a count for the bucket, but if it is blank then enpty bucket is shown there. (We need to show the previous value to this empty bucket).

 


Example
:


- Company A has no value in 120 and 365 day, so both must show the value "6" which is of 90 days.
- Company Q has value only in "7 day column" that is 4, and rest are blank! So it must show "4" in all the other empty buckets (since it is the last value counted).

Here is the Sample Data