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
And so on... and at the end the TOTAL row.
How can I do that
Use rowno() in expression
if(dimensionality()=0,count(distinct [Codigo Solicitante]), rowno() )
Juan, go to the pivot table, on the expression put "=RowNo()"
Retrieving data ...