Last week tfc

[marikabi]

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