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
See if this technique helps you solve it.
Note that if you want to switch between Years, you’ll have to add conditional logic for that, for example by adding a parameter.
