实现分组求max后再sum

janejin 1 Reputation point
2020-08-14T05:06:58.56+00:00

17509-image.png

Picture1 is my base data. How can I get such result(picture 2)?
17527-image.png

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
39,702 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2020-08-14T12:20:31.19+00:00

    QnA forums are currently English only. The migration notification you're seeing is in error. Only the English TechNet / MSDN forums are currently in migration. You can disregard notice, they're actively answering question in dedicated forums here.
    https://social.technet.microsoft.com/Forums/zh-CN/home

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.