Trying to use OVER function to count across all rows

[Brian Bennett]

I want to use the over function to count the unique number of weeks in the filtered data set in a cross table.

 

Uniquecount(Week([DATE]) over All(Axis.Rows) ) is what I think I should use but it isn't working.

This is what Uniquecount(Week([DATE])) is returning-

Name Weeks

Dave 12

John 11

Steve 13

 

I want the following-

Name Weeks

Dave 13

John 13

Steve 13

 

Now, I am using this in a calculation on top of that, but this is where I am stuck. I am going to use this to count a number of events per week and I want to count all weeks in the data set, not just those that the individual happended to record an event.

[Naveen Tibco]

Hello Brian,

 

please try this calculated field

 

Max([weeks]) OVER (All([Names]))

 

 

 

Thanks

 

Naveen