Trying to get a aggr, rank expression to work over a time field within a Parent, Child and 3rd dimension, either Type or Group.
I've attached a Rank_Test.qvw, and a screenshot. The first aggr(rank( expression works (with the exception that it's ranking them in reverse order?), but I can't get it to rank over the the third dimension -> Type or Group. It ranks the first of each Type, and the first of each Group. So if there is a 3 Type1, and 2 Type 2 and 3 Type 3. It will rank the 1st Type1, the 1st Type2 and the first Type3. But I want it to rank the 3 Type1, and rank the 2 Type3 and the 3 Type3 independently. ie., Give the 3 Type1's each a 1, 2 and 3 rank, then rank the 2 Type2 as 1 and 2, and then rank the 3 Type3 as 1, 2 and 3. And do the same thing for Group.
