Any of you that knows how to sort for each year. I couldn’t used the matrix table as I can only sort by total not each year.
So if you can see the picture below (PIC 1), I have used zebra table. But that one is to paid and on trial licenses. Any of you had any ideas?
I have tried but in a long way. The way that I did is do the calculation for each year. Then, create a table (not a matrix) from there you can just click on the header as shown in pic 2.
Pic 1. Here you can see the arrow showing that I’m sorting on year 2018
Pic 2. Here you can see the arrow showing that I’m sorting on year 2020