How to merge rows with the same value from sql result

Hello everyone

How to implement my requirement like the picture as below

This is original data

to approach my requirement firstly I created an sql

SELECT {Estimation}.[OpportunityId],
    sum({Estimation}.[Amount]) over (PARTITION BY {Estimation}.[OpportunityId],{Estimation}.[EstimationDate]) AS TotalAmount
FROM {Estimation}

This is my SQL result

This is my result shown on the screen

Appreciate if someone can provide me help on this, thanks very much.



Hi May,

Here is one similar post on forum with solution. You can try this.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.