Pivot Item selection error

i see your profile says 2013...if your only wanting one item from one pivot
you may be better off using pivotfield/pagefield
http://www.thespreadsheetguru.com/bl...l-pivot-tables
see section Report Filter On A Single Item

however if you still want to use pivot items
see section Report Filter On Multiple Items of the website

if you want to learn how to loop the pivot items instead of setting one by one
see post #2 on this thread to see how to i use set Pivot items syntax
its pretty similar to what your asking however i am doing multiple pivot tables with one cell
http://www.excelforum.com/excel-prog...ot-tables.html