I have a pivot table where I'm trying to add a Rank column that will Rank the number of Doors Produced by Efficiency Group (the first dimension in the pivot table). I'm using an aggregate function along with the Rank function and can't seem to get it to rank the number by the first dimension groupings. Here are the expressions that I've tried with various results that are incorrect.
aggr(Rank(sum([qty-prod]/[reg-hour] + [ot-hour]),3,0), [short name], [entity name], shift)
aggr(Rank(sum([qty-prod]/[reg-hour] + [ot-hour]),3,0), [short name])
aggr(Rank(sum([qty-prod]/[reg-hour] + [ot-hour]),3,0), [short name], [entity name])
Rank(sum([qty-prod]/[reg-hour] + [ot-hour]),3,0)
Here is a screen print of the pivot table. What I would like is for the grouping "Exterior 90 minute" to be ranked as 1 - 5 and then "exterior stock line 1" ranked as 1-2.
