If value is zero, show previous non-zero value

[rosemary]

Hi Experts,

I have below data set:

Country	Month	New Contacts	Total Contacts
Hong Kong	2020-01	0	0
Hong Kong	2020-02	3	3
Hong Kong	2020-03	5	8
Hong Kong	2020-04	10	18
Hong Kong	2020-05	4	22
Hong Kong	2020-06	2	24
Hong Kong	2020-07	14	38
Hong Kong	2020-08	10	48
Hong Kong	2020-09	6	54
Hong Kong	2020-10	14	68
Hong Kong	2020-11	18	86
Hong Kong	2020-12	12	98
Hong Kong	2021-01	0	0

Las column is showing a cumulative values. The thing is I need to have for the last Column - Total Contacts, last max value - which in this example is 98. So it should look like below: 

Country	Month	New Contacts	Total Contacts
Hong Kong	2020-01	0	0
Hong Kong	2020-02	3	3
Hong Kong	2020-03	5	8
Hong Kong	2020-04	10	18
Hong Kong	2020-05	4	22
Hong Kong	2020-06	2	24
Hong Kong	2020-07	14	38
Hong Kong	2020-08	10	48
Hong Kong	2020-09	6	54
Hong Kong	2020-10	14	68
Hong Kong	2020-11	18	86
Hong Kong	2020-12	12	98
Hong Kong	2021-01	0	98

Can you help me with that?

Rosemary

[GaryGiles]

To achieve the resulting table, you could have Country and Month as Dimensions.  Add [New Contacts] as a measure twice with no aggregation function.   In the properties panel of the second measure, use a Modifier of Accumulation.  The Modifier option is just below the Measure Expression definition.  Set the Accumulation Dimension to Month and Range to Full.  The limitation is that you can only have up to 2 dimensions in the table.

[Ksrinivasan]

hi,

find your chart expression is 

rangesum(above(Sum([New Contacts]),0,RowNo()))

Ksrinivasan