numbers in pivot table

[Anonymous]

Hello,

I have this pivot table and I have a dimension called "Codigo Solicitante", now I want to coutn ALL this rows, but in a new colum assign a number:

Codigo Solicitante                         Number

174903284                                        1

121497643                                        2

       .                                                .

       .                                                .

And so on... and at the end the TOTAL row.

How can I do that

[kaushiknsolanki]

HI,

     Use rowno() in expression

Regards,

Kaushik Solanki

[swuehl]

Try this

if(dimensionality()=0,count(distinct [Codigo Solicitante]), rowno() )

[jvitantonio · Accepted solution]

Juan, go to the pivot table, on the expression put "=RowNo()"