Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Juan, go to the pivot table, on the expression put "=RowNo()"
HI,
Use rowno() in expression
Regards,
Kaushik Solanki
Try this
if(dimensionality()=0,count(distinct [Codigo Solicitante]), rowno() )
Juan, go to the pivot table, on the expression put "=RowNo()"