How to create month column using only with latest date

[Manjunath Jannu]

Hi Team

I have one small requirement need your quick assistance on this.

I have sales for 4 weeks in that 4th week is showing sum of all there week

So now wanted show month wise data.

If i select any month it should calculate(sum) using latest week because last week having sum of all week (last date).

How to create month column using only with latest date(week)

 

Please schedule a zoom meeting if you need further details on this issue(available from 11am to 7am IST)

[Fabian Duerr]

I'm not sure if I understand this right... but the latest week will always have the largest value of the month. So, you could simply work with a max() OVER ... function. 

 

If you need further support then please but some sample data here. It's important to understand your data structure.