I have a Pivot Table, and I'm using aggr with a rank function as a dimension. Here's the dimension:
aggr(rank(aggr(sum(Value),Field1,Field2,Field3,Field4),4,1),Field1,Field2,Field3,Field4)
I'm also using Fields 1, 2, and 3 as Dimensions, and I really want to aggregate on Field 4, but get a seperate ranking for each of the other dimensions. This is working ok so far.
If I want to collapse a dimension in the pivot table, it messes everything up. I assume it's because I'm aggregating and ranking by each of the dimensions. Is there a way to be able to collapse a dimension, and keep an accurate ranking within the dimensions I have open?
