Problem to manipulate data as pivot table in excel

I have this worksheet and I’m trying to use pivot table to show how much any seller (column “Nome”) has sold in wich sale’s place (column “unid de vendas”) and than show all of columns. But I need show it one seller per time in order to save the amount per seller in PDF and than send it by e-mail.
But I really don’t know how to do this. I’ll upload my excel sheet if anyone could help me I’ll be thankful. ResumoComissaoEspecial.xlsx (69.4 KB)

1 Like