Forum Discussion

mape's avatar
mape
Frequent Visitor
8 years ago

In a matrix, how I can replace values in empty cells with values of previous cells ?

Hi everyone!! I need help about this...   Measure of sales per year and in case there is no information for that year, show the sales of the previous year.   That is, given a series of sales per ...
mape's avatar
mape
Frequent Visitor
8 years ago

Hi Abduvali

 

That is fantastic!! thank you, now it works, I was creating a calculated column instead of a measurement.

I have a new doubt, if I wanted to do it for the months, would it work the same way? , for example, if call ustomers all have sales in May but in November only some customer have it, and I want those that are blank in November to show me the May sales, how would it be in this case?

 

:)

 

mape's avatar
mape
Frequent Visitor
8 years ago

Hi @Abduvali

 

That is fantastic!! thank you, now it works, I was creating a calculated column instead of a measurement.

I have a new doubt, if I wanted to do it for the months, would it work the same way? , for example, if call ustomers all have sales in May but in November only some customer have it, and I want those that are blank in November to show me the May sales, how would it be in this case?

 

Smiley Happy