Forum Discussion
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
- lbendlinSuper User
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.