Hi all,
I have a problem with a expression.
My formula is:
=aggr( Count({< OrderDate= {"$(=date(FirstSortedValue(distinct OrderDate, aggr(OrderDate, OrderNumber))))"}>} OrderNumber), OrderNumber)
What I try to achieve is that QV takes the first OrderDate value for each OrderNumber and counts the number of rows that have that OrderNumber in combination with the first OrderDate.
QV at the moment validates the OrderDate with the firstsortedvalue of alle the orderdates in the selection.
Where am I going wrong in my expression?
Much thanks in advance!