Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Can anybody help or advize me with the next expression?
I need the result from column X of WeekEinde 28-6-2015 to show in the dashboard as month Juny
I do not want to change the calendar, because not all the data is a count like that, mostly it is a sum of the data from the weeks belong Juny..
if(Max(WeekEinde) < JaarMaand, sum(X))
Thanks already!
hi
something isn't clear enough for me in your expression
you compare to fields that contains different set of data
you can try
=FirstSortedValue(aggr(sum(X),WeekEinde),aggr(-WeekEinde,WeekEinde))
Hello Liron,
Your answer works fine!
Thanx very much for the hint.
Greets, Nelly
hi good to hear
so please mark the answer as correct so future users could benefit from it also