
drilldown Aggr in multiple dimension pivot table  how
M Paeper Jun 6, 2012 11:18 AM (in response to M Paeper)Figured it out after posting.
Sum(Aggr(ClockHrs,Operator))
as the expression gives me the correct answer and aggregates at all pivot table dimension drill down/up levels.

Re: drilldown Aggr in multiple dimension pivot table  how
M Paeper Jun 21, 2012 4:29 AM (in response to M Paeper)Not so fast.
I discovered recently that my discovery wasnt quite that simple  while the above works for a single period when factoring in date dimensions things get more complicated and when doing a Pivot table  you get results that work for a particular date but then when you drag your slider over a date range things start falling apart and you see no or only one aggregation but not for all the dates.
I'll show the formula I presently use which gives me pivot table driill down over multiple dates and all the dimensions I have. Effectively what seems to be required is at the Aggr(expression,dimension) level one adds all the dimensions comma separated in sequence from lowest to highest level of aggregation required.
e.g.
Sum(Aggr((totalTime+overTimeabsentTime),Operator,workCenter,CalendarDate,ProdCalWeekNumber,MonthName,YearName))
In practice it looks like this
HTH
