Category
Report Builder
Product Version
8.0
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:
The same question
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!