Row no in dimension of chart

[#1]

HI All,

I want to add row no in dimension of chart.Please assist me in this.

I want my chart looks like this:

SR NO.           Service              Adddress              Customer Name

1                      abc                   London                 Alice

2                      lmn12                Paris                   Steve

3                      mnsg9               Africa                   Aden

Sr no and service are the dimension

address and customer name is expresion.

Currently my chart looks like this:

.           Service              Adddress              Customer Name

                abc                  London                 Alice

                lmn12              Paris                   Steve

               mnsg9               Africa                   Aden

How to add the sr no  column in the chart .Please help me in this.

[#2]

load

Service ,   

         Adddress ,

            [Customer Name] ,

rowno() as [SR NO.]

from table;

then in chart use these field. on the basis of [SR NO.]

[#3]

example

in script write this

LOAD RowNo() as [SR NO.], * INLINE [

    Service, Adddress, Customer Name

    abc, London, Alice

    lmn12, Paris, Steve

    mnsg9, Africa, Ade

];

then in pivot chart

dimension-     [SR NO.]

                     Service

Expression--     Adddress  

                        Customer Name

SR NO.	Service	Adddress	[Customer Name]
1	abc	London	Alice
2	lmn12	Paris	Steve
3	mnsg9	Africa	Ade

SEE ATTACHEMENT

[kumarnatarajan · Accepted solution]

Hi,

Use Row() Function in your expression. then drag to first column.

find the attached file.

Else

Use Row() as SNo function in your load statement.

[#5]

Thanks for the reply.

It helps me...