Report only latest row from group
Answered
I have a dataset that I am reporting on - I want to report on only the latest/most recent of a group of items. For example, I have three entries for Shoes, I only want to include the most recently updated on on my report. I have it sorting by date - so the last or first entry in a group would work as well.
Example:
Hello Cody,
You should be able to use the 'Max' Aggregation option on that date field to return only the most recent result.
Here is the Wiki document on Aggregation: https://wiki.yellowfinbi.com/display/yfcurrent/Aggregation
Please let me know if that works for you.
Have a great day!
David
Hi Cody,
Hope you're having a good week.
Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?
Regards,
David
Hello Cody,
Hope you're having a good week.
Just wanted to check-in and see how it's all going. Was there anything you were needing from me to help get this resolved?
Thank you,
David
Hi,
I hope things are going well over there.
Assuming we're all good here, so I'll flag this as answered. However, if you ever wanted to re-visit this or have anything else I can help you with, please let me know.
Have a great day!
David
Comments have been locked on this page!