I need a help in creating a ranking in a PivotTable, the example I have several collections 451,452,453,454. But the ranking that would be like to ride only within each collection and not taking the general among them, follows the expression I'm using, grateful.
IF (RANK (AGGR TOTAL (SUM (QTDE_PEDIDA2) COD_COLEÇÃO, Reference), 0,1)> 0, RANK (AGGR TOTAL (SUM (QTDE_PEDIDA2) COD_COLEÇÃO, REFERENCE) 0.0 )&'.º')
