How to insert group rank in straight table only using "Column(ColumNo)" function?

[hyunquijote]

Hi. I'm using QlikView 9.0 version.

I want to insert group rank like under picture. and highlighted rank 1,2,3 on TEAM Dimension.

Only using Column(ColumNo) function. "TEAM" is Demenion.

I tried this sentence. but It's not work

< ex. aggr(rank(column(2),4,1),column(1)) >

please help me..

[sunny_talwar]

How about this

Aggr(
  Rank(CountExpression)
, GROUP, TEAM)