Color of total rows in pivot table

[ahmedwank]

hi all

i would like to know which fonction can calculate and give me the result in a text box the total number of rows i have in my pivot table 

thanks

[Claudiu_Anghelescu]

if you have a distinct field in the table you can try;
=count (DISTINCT Field)