3 Replies Latest reply on Apr 8, 2011 4:44 AM by tommyodell

    Rank Within Partition

    Santiago Restrepo

      Is there a way to use the Index() function within a partition, so that the ranking starts from 1 once a new partition starts?

       

      For example, in the attached file, the SKUs are sorted descending, based on the sales units.

      I need the 1st SKU in "Product 2" (SKU12) to be ranked #1 (not # 10), and from there continue the ranking for the SKUs within "Product 2"