Formula needed for Pivot Table

[srizki]

I am using this formula

=REPT("|",GETPIVOTDATA("Notes",$A$3,"Employee Name","Paul","Filter","Non Productive")*5)

Paul is on A5, and I want to be able to drag down this formula. I have 356 row, If I drag down this formula as is, it gives me the result of first formula, there fore I have to retype this formula for each row.

Please correct the formula.

thanks.

 

[snoopyhr]

try this site, good illustration and explanation....

http://support.microsoft.com/kb/287736

 

[srizki]

Thanks Snoopyhr, this page is good, but unfortunately it does not give the answer I am looking for, but it is worth reading.

Thanks again