Adding row count to the left of a straight table in a Chart

[#1]

Hi,

How can i add a row count to the left side of a table like this, when the table is sorted to show only the 5 top publishers:

Row No	Publisher	Revenue
1	Guy	1000$
2	Dav	850$
3	Best	701$
4	Mam	300$
5	Nana	139$

Thanks,

Guy

[jykang0638]

Hi Guy,

You can achieve through using RowNo(TOTAL).
Add expression above and move the column before Publisher column.

I hope it helps you.
Steve Kang.

[#3]

Hi,

It works partly. I am using Straight Table Chart, and the RowNo(TOTAL) expression indeed show the row number, but it also destroys the sorting of the table, so i can not sort it by column Revenue.

Maybe there is solution to this sort problem?

Thanks,

Guy

[swuehl]

If the sort by revenue will not be changed,  the row number equals the rank by sum(Revenue), right?

So you could try using a rank function, like

=rank(sum(Revenue))

instead of the rowno(total) expression.

(For any reason, if you use a chart inter record function like rowno(), the reference states:

Note!
Sorting on y-values in charts or sorting by expression columns in straight tables is not allowed when Chart Inter Record functions are used in any of the chart's expressions. These sort alternatives are therefore automatically disabled.

)

If your Revenue values are not distinct, you probably need to check out the mode and format parameter to rank() function, please refer to the Help for that.

Regards,

Stefan

[rwunderlich]

Go to the sort tab for the table and uncheck all the options for the RowNo column.

-Rob

[#6]

Hi,

Its helps, the row numbers are shown when using Rank function, but the problem is when i try to move the Rank column to the left of the table,  it loses its numbers...

Thanks a lot anyway!

Guy

[#7]

Hi,

Unchecking in the Sort Tab didn't help.

Thanks,

Guy

[jykang0638 · Accepted solution]

Hi Guy,

Do you open the qvw that created by others? i.e you must have a desktop license or can lease a license from QVS.
If you can, refer to attached qvw.

Steve Kang

[#9]

Thank you! it is an interesting way to solve this problem.