Pivot Table Help (somewhat complex)

[Anonymous]

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))

[Anonymous]

Bump