rank

[alexpanjhc]

Hi

I am not able to figure out the rank, hrank functions.

I have a pivot table that I have 2 demisions.

but I need to rank the entire pivot table.

It looks like rank() only rankd the columns and hrank() ranks the rows.

I need to rank the entire piovt table, how do I do that?

Thanks!

[#2]

what You mean rank entire pivot table?

could You describe Your objects/expressions/dimensions?

[swuehl · Accepted solution]

Try using something like

=aggr( rank(TOTAL sum(Value)), DIM1, DIM2)

where you list all your table dimension fields in the aggr() function (replacing DIM1, DIM2 with the dimension fields).

[alexpanjhc]

Great, Thanks swuehl!