Help With Pivot table

Hey I use the create pivot table activity but the table created looks like this


Is there a way the table can look like this when is created manually?

Hi!

Maybe you could try by recording a macro in Excel and using the Invoke VBA Activity instead of Create Pivot Table.

To be able to record a macro you have to enable the developer mode first. Go to File → More → Options → Customize Ribbon

Then press the record macro and stop recording after you performed your actions. You will be resulted with a VBA code.

Hope this helps!