Thread: Add calculated item to pivot table

Hi

Try the formulas below, and do a really good test of the result. I think it is OK. I've done it from the start of the data to make sure it has enough data to do a full test.

You will have to expand the range, but that can be worked on later.

N2: =VLOOKUP(B2,'Com Target'!$A$2:$C$7,3,FALSE)
O2: =IF(AND(K2>N2,OR(B2="leanne",B2="Gemma S",B2="Bev",B2="Aimee"),SUMPRODUCT(--($B$2:B2=B2),--($E$2:E2=E2),--($G$2:G2=G2))=SUMPRODUCT(--($B$2:$B$500=B2),--($E$2:$E$500=E2),--($G$2:$G$500=G2))),M2+10,M2)

Copy down.

This should find the last instance of the successful commission payment for the person, and add the bonus.


rylo

Thanks Rylo

That worked a treat - put it through it's paces last night - no problems - so all solved now.

Thanks for your time and patience.

Tony