Not getting cumulative count

[Anonymous]

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

[amitchandak · Accepted solution]

@varunt , Please find the attachment after signing

[Anonymous]

Thank You @amitchandak for the quick help. It is relly helpful.
I appreciate the efforts to the community 🙂