If you have stock pictures on the same date for all items, use a set analysis as following:
If Max date is not the same for items use this one:
Please find attached an exemple based on your data set
MaxDate.qvw 150.5 K
Unfortunately this is not the case, values can change at different times for different items.
I managed to accomplish to only select the last reported date and then present the Item for that but it was the last item not all items. I need to display a value (the last reported one) for each item.
Kindly find the attachment.
In script level create a table by using resident load and apply the group by clause.
LOAD A,Date(Max(Date)) as MaxDate
Group by A;
ITEMS.qvw 150.0 K