In outsystems I have an aggregate with the following output:
Id x
Week 1
Hours 15
Week 2
Hours 10
Week 3
Hours 8
Id y
Hours 20
Hours 12
Hours 12 etc.
I need a table filled as folowed:
Week 1 Week 2 Week 3
Hours Hours Hours
Id x 15 10 8
Id y 20 12 12 etc
I'm struggling for a long time now with this problem and hope someone can help me. solve this problem on the serverside.
Dear,
Kindly find the solution below and also I have attached the application file for your reference, you the Idea behind is using Advanced SQL aggregate.
Please mark it as a solution if it fulfills your request.
The aggregate output is not clear for me, can you send them again as a screenshot in a table format like excel?
Hi Ahmed,Thank you for answer,
Here 2 examplescreens
Hope this will make my problem (question) more clear.
Hi Ahmed,
This is exactly what I need. You helped me a lot.
Thank you very much.
I think that more people will find your solution very usefull.
Regards,
Erio