Hello guys,
I have a table with only one dimension: YEAR
What I need to do, is to find an expression to calculate the total traffic volume for the last available week.
eg year 2016 --> week 52
year 2017 --> week 20
I'm using the expression: FirstSortedValue( aggr(sum([TOTAL TRAFFIC]),W_order), Aggr(-W_order,W_order))
It works ok for the 2016, but it takes the week 52 also for the 2017.
I think I need to put a condition like :" where total traffic is greater than 0"
Do you have any idea?
Many thanks in advance