Fake Week and Sum with Month
Hi, want to SUM value with Month.
I set the time setting as "Week General".
It has no month aggregation, so I made the Month List.
And I calculated month value as a described below.
TimeSum(Weekvalue, start, end)
I read this article.
But I want to Sum month value more simpler.
I think I should make fake week, Like this.
|Jun-21||W/c 28 Jun 20||6/28||7/4||6/28||6/30|
|Jul-21||W/c 5 Jul 21||7/5||7/11||7/1||7/11|
|W/c 12 Jul 21||7/12||7/19||7/12||7/19|
|W/c 26 Jul 21||7/26||8/2||7/26||7/31|
I have to adjust the start and day Properties.
And I think can use "Timesum" value with "start(adj)" and "end(adj)".
But I couldn't do this because of the restriction of "Timesum" function.
Do you have any solution?
I read this article, but the start/end date of week was same between "Real Week" and "Fake Week".