Rank in Straight table by specific dimension

[#1]

I have a straight table that has multiple dimensions, but I want to rank on a specific dimension, how can I do this.  Here is my current definition

=

RANk((sum(Quantity)* AVG(NumberOfItemInSet))/IntroDateDif)

That works but I need it to rank on just the one dimension field names "Item".

Thanks in Advance

[Vegar]

Hi ljames77

I think you can use the TOTAL aggregation, but ignore your desired fieldname. rank([ total ] expression [ , mode [, format ] ])

RANk(TOTAL <Item> (sum(Quantity)* AVG(NumberOfItemInSet))/IntroDateDif)

Best regards

Vegar Lie Arntsen

QlikView consultant at egbs consulting ab

Blog (in Swedish): bi-effekten.se