You can add a field to the source data, as described here:
http://www.contextures.com/xlPivot07.html#Unique
and use that field to count the occurrences of the sales_doc_#
> i have uploaded screen shot of my pivot table at
> http://www.sunagusa.com/pivot_exampls.gif
[quoted text clipped - 4 lines]
>
> my email id is ghodasara@gmail.com

Signature
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html