How do I Calculate the row % change when there are missing values in a Matrix

[jchen4016]

Hi I am having trouble with calculating the % difference between rows when there are empty values. 

My Variables are as followed:

C$ is the values

Countries is the different contries names

DATA_MONTH represents the time. 

Here is a screenshot of the data table: 

 

I used the Matrix visual, put DATA_MONTH in Rows, Countris in Columns and C$ in Values. Notice that there are some missing values here and there, how do i calcuate the row % change from here ? 

[Anonymous]

Dear @jchen4016 ,

What is the expected behavior in the columns with empty cells?

What should a cell below an empty cell show:

• The % change compared with the previous cell that has a value
• No value (or a dash)
• Infinite
• ...

BR

Martin