issue on Pivot table

[#1]

Hi friends

i have a field called Rank based on this field i need to display top 10 Ranks in Pivot Table.i have only one number field i.e Rank field .so how write expression for This and how to create pivot table and how to filter it for Top-10 values

Rank fields  having

1)'NUll'

2)0

3)1

4)2

5)222

6)523

like that ...Null means which is directly coming from database

Thanks

[Saravanan_Desingh]

I tried with few assumptions. Please check.

NULL was considered as String here

Not sure, how you want the Pivot table with single Field. I assumed the expression as Rank(Rank).

Let me know if you need something different.

[#3]

hi

if i apply rank(rank) i am getting only1 for complete table and i have few more fields among that ineed to filter the data based on Rank(Number field)field using pivot table.

Thanks

[Saravanan_Desingh]

Hi,

I still could not understand your requirements. I assume, you are struggling with Rank function, along with few more fields.

I have changed my example with two fields.

If you could post your App and explain with an example, it would help me to understand you issue.