Resetting rank

[Sameer9585]

hi,

I required the desired rank column in the given excel below.

At the month end date and max of the last month I need numbering in the descending order .

Please look into the excel for better understanding.

Thanks

[Anil_Babu_Samineni]

Perhaps simply like

Table:
Load * From <Excel>;

Left Join(Table)

Load Date, Category, Flag, If(Flag<>0, RowNo()) as Desired Rank Resident Table Order By Date asc;

[Sameer9585]

hi Anil,

Thanks for quick reply if there are two or more products then the number is not correct

[Anil_Babu_Samineni]

You meant as follows?

[Sameer9585]

hi anil,

Please find the updated excel.

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

Table:
LOAD Date,
Category,
Product,
Flag
FROM
[Comm1.xlsx]
(ooxml, embedded labels, table is Sheet1);
Left Join
Load *, If(Flag<>0, AutoNumber(RecNo(), Product), '') as Dense_Rank Resident Table Order By Date desc;