Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Thank you in advance for your help.
I have a pivot table below that calculates the "Actual", "Scheduled", "Budget" for the week.
I want to add a measure that has "Weekly Average" using the past 6 months. This measure excludes any "time series dimensions" as users will be changing the weeks they will be evaluating.
I created the set analysis below but it doesn't work in the pivot table (Note - I tried ignore the timing dimension [Period NameN]=)
If I take the same set analysis below and put it into a KPI.. it calculates fine.
I have a feeling the dimension column (Weekly intervals) is screwing with the set analysis for that measure.
As mentioned before, I tried to ignore that dimension [Period NameN]= but I don't think that worked.
(Count({<WeekDay={'Mon'},
[Period Name]={'6 Month Rolling'}
,[Period NameN]=>}
AccountCount)
/
Count({<WeekDay={'Mon'},
[Period Name]={'6 Month Rolling'}
,[Period NameN]=>}WeekDay))
Bump