Forum Discussion

WJ876400's avatar
WJ876400
Helper IV
4 years ago
Solved

percentage Difference

Hi

 

I have a data set which tracks monthly data by a learning programme. The table shows the programme, the date and then a count of which programmes are green, red and amber. I have then created a matrix to show the difference in red programmes over the last two months. What I want to add in is the percentage difference for each programme between the months.

 

This is the matrix table -

and this is the raw data

so the data looks the same for February and I just simply pull the course into rows, the month into columns and the number of red programmes to values. I just want to see the percentage difference by programme from month to month as next month I will compare March and February

 

thanks very much

 

 

  • Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.

    Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

1 Reply

  • Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.

    Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.