Can I use a function instead of a dimension in an aggr?

[#1]

I would like to create an aggr expression, using the function WeekDay() as the aggr field.  Does anyone know if there is a way to do this?  Just replacing the dimension with WeekDay() returns null values.  I want to show the average sales for each day of the week (average for a Sunday, Monday, etc).

avg(aggr(sum(NET_SALES), WeekDay()))

Thank you!

[MayilVahanan]

HI

Try like this,

In script, load weekdays and then use it as dimesion

Hope that helps

[swuehl]

I believe an aggr() dimension must be a field, not a calculated dimension. So, if possible, it would be easiest to create that field in the script.