Grouped variables in graphs

[#1]

Hi,

I have weekly level data that I have grouped date, month and year for drilling. As I look data at the month level I would like to see the net sum of flow variable (price change) and the latest value of month for stock variable (stock level).

I have attached an example data. E.g. for jan 13 I would like to have the value of 29.1.2013 not the average of month (as I have at the moment ).

Does anyone have any good solutions?

[Gysbert_Wassenaar · Accepted solution]

FirstSortedValue([Stock level],-Date). See attached qvw.

[#3]

Thanks!

As I was creating the example I didn't think that there are more dimensions and thus [Stock level] is not one value but sum of stock values over products etc. But I think I figured it out correctly

=FirstSortedValue(distinct Aggr(sum([Stock level]), Date), -Date)