ranking in report

[ari_meta]

Hi all

  I want to fine out top 3 product lines according to number of quantity got sold month wise.

any idea

Thanks

Ari

[MFGF]

Create a list report with Month, Product Line and Quantity as columns.  Group on the Month column.  Add a Query Calculation to your report called Rank with the expression rank([Quantity] for [Month]) then filter on this with the expression [Rank] <= 3

MF.

[ari_meta]

Thanks , it works