About Pivot table

hi everyone,

My excel data have 28 columns and 600 rows, I want to pivot it,
i use “create table” (A) and “create Pivot table”,
how can i only choice what i want item on specify position not all in the same chart?
Can anyone help me on this? thanks in advance


Please find the Attached Code which i have used to implement the pivot table and there are lot of columns but i have selected some of the columns and used one function too.

Modify the code according to your requirement and use invoke code activity VB.net option to create pivot table in your excel. Try and let me know. Thanks.

Pivot Code.txt (2.7 KB)



Hello Phoebe,
Here I have a Video with code of how I create Pivot Tabel: