How can i make a table with week range

[#1]

Hi community,

I want to make a table like this but i dont knwo what expression i can make

Week    Sales

31-41     100M

32-41      90M

33-41      65M

Can anyone tell me how to do it

[#2]

And also i have a range of week 27-45

How can i set the range be 31-41?

[tresesco]

Could you provide a sample input data and expected output against that?

[#4]

I have the following expression now

Dimension:class(Floor(Week),1)

Measurement:Sum(DISTINCT {<Week = {">=$(=31)<$(=41)"} >} LineTotalSales )

The outcome is:

[#5]

But i WANT

31<X<41

32<X<41

33<X<41

34<X<41

what should i modify in order to get the dimension likes this

[tresesco]

For these uneven intervals class() alone might not be enough here. I guess you might have to take some help from the-as-of-table‌ concept or, a little complex and not-so-nice solution using synthetic dimension. Try to share your sample raw data (in excel may be).