@rumm.an Tried doing it like in your code but got the error "Trying to get property of non-object" so i commented out the {{$product->name}} and the rest of the code worked. So that's one issue less, any thoughts on how to resolve it? I also noticed that my result isn't grouped as you pointed out. Reason I wanted to group is so that for each date, a table is displayed with the product name column and the cost column. so if i have 3 different dates, that will be 3 different tables. With my current code, I'm displaying 9 tables which isn't what i want. Any thoughts on the best way to achieve desired result?
it might help if you consider the effect of grouping
You don't have a collection of prices, you have a collection of dates, each date can have many prices so you need to work from the outside date element first
@Snapey Tried it out and got a table for each date for each product. Similar to the previous code. Had little sleep trying to figure this out, still sweating it.
@rumm.an problem solved, thanks to your solution. If you have the time, please drop a note for those of us learning so we understand better what we were doing wrong. Cheers