Hi,
I have the attached data which I'm using in my data model (Week Field and Sales Field), so now my requirement is I've to load data until current week in current year.
For example today is 09/21/2021 and week number is 38, so I'm looking for a set analysis expression to sum the sales until current week (from wk1 - wk38). Next week it has sum the sales until week 39 (from wk1 - wk39).
Along with that I'm looking for a line chart to load data until current week i.e. 38 as below.