Glad to help 😃
ValueList() creates a field with some values, it's often used for creating a dimensions.
If we have numeric values like ValueList(1,2,3) then we can use Pick() for setting an expression values for it:
=pick(
valuelist(1,2,3)
,sum(sales)
,count(orders)
,count(customers)
)
But, if we have a string values such as ValueList('jan', 'feb', 'mar') than we can't use Pick() function directly, we should use Match() function for support:
pick(
match(
valuelist('jan', 'feb', 'mar')
,'jan'
,'feb'
,'mar'
) //will return 1,2,3 respectively
,sum({<mon={'jan'}>}sales)
,sum({<mon={'feb'}>}sales)
,sum({<mon={'mar'}>}sales)
)
In your case I've created one valued field with ValueList(Year) and when a user selecting some year the value of ValueList(Year) is changing.
Then all I've to do is set different expressions for different calculations (Y-0 and Y-1, Point and Values).
And there no difference between Y - 0 and Y, it's the matter of taste 😃
Hope I didn't explane it confusedly.
