Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have below table :-
I wish to show the sum of value corresponding to week opening of each month.
I created week opening dates from Report Date in the above table.
Now , I wish to show only 79 corresponding to 10/04/20222. in the measure .
Right now when I am trying to show , it is prompting me total values of all the days present inside that week like below :-
I think , it can be achieved via set analysis but I am not able to understand how ?
Can anyone please help ?
Thanks in advance
So, the main question for me is: Do you want to group by week start, or do you want to filter on week start?
If "group by", then
If "filter", then
If you want to show the Sum() for the entire week on the weekstart, you should simply remove the REPORT_DATE from the dimensions. But keep the "LOB_trend" and add "=WeekStart(REPORT_DATE)" as dimension.
Thank you @hic for your response. However I need to show the report date in my table. And if you will see in the above screenshot , I have created a dimension comprising only weekstart dates of each month. But those dates are showing cumulative sum of all the days in a week instead of single opening date. Please help
So, the main question for me is: Do you want to group by week start, or do you want to filter on week start?
If "group by", then
If "filter", then
I tried by removing Report date from dimension but it is still giving me the cumulative sum :-
Weekstart for all those dates is "4th Apr". so its give cumulative values - 493.
If you want to see only sunday date, then u can include set analysis something like below.
Dim: REPORT_DATE
Exp: Sum({<WeekDay={'Sun'}>} TREND_VOL)