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?
Hey I use the create pivot table activity but the table created looks like this
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!