how to display bottom N values including 0 values using Rank function

[Manish]

Hi Guys 

I want to display bottom N values including 0 values in a straight table having 2 dimensions and 1 Expression.

I am attaching a sample qvw file. 

When i am trying to show bottom 5 , i am getting below output 

Team	Office
A	O1	-100
E	O5	-50
F	O6	-40

Expected Output:

Team	Office
A	O1	-100
E	O5	-50
F	O6	-40
B	O2	0
C	O3	0

Please let me know what i am doing wrong.

Thanks in advance.

[MayilVahanan · Accepted solution]

Hi @Manish 

PFA