Hi all!
My scenario is the following: Canvas App Embedded in a model driven app.
I am creating a gallery that has to show me items related to the record i am in, groping them by one of the fields and also get the sum of some fields in those records. I managed to do this easily with the GroupBy function and then adding a column where i make the sum of some fields from the related entities. In my opinion this is the best way to achieve this (see screenshot attached, I already have the result I need), however I was wondering whether I can avoid using the GroupBy and use a Distinct function.
The idea should be that when I do the distinct, the resulting table will have a column with the calculated sum ot the records.
Please let me know if there is a better way to do this using distinct or if I should stick with the working GroupBy.
Nik
