Max week as a calculated dimesion

[#1]

Hi, guys!

I have a number of weeks in my file. For pivot table I want just the last week as a dimension.

Any suggestions how to do that?

[MK_QSL]

How is your week field? ie. normal week number of weekyear?

Use below

=Max(TOTAL {<Year= {'$(=Max(Year))'}>}Week)

[#3]

I just have dates as like DD-MMM as a week

[rajkumarb]

hi

you can use Week(max(field name))

[#5]

Hi, it's not working

[rajkumarb]

hI diana

=Max(WEEK(weekstart(date_field_name)))

[MK_QSL]

=Max(TOTAL {<Year= {'$(=Max(Year))'}>}(Date#(Week,'DD-MMM')))

[ramoncova06 · Accepted solution]

if you want to use is as a dimension, then you need to use aggr

=aggr(max(WEEK),$Field)

though this is conditioned to how you date is set up so you might want change it to a date format something like date(your date&'-'year), so then it would be recognized as a number instead of a string