Create Pivot tables in excel

activities
studio

#1

In my requirement, I need to create pivot tables from the existing table, can anyone suggest how to proceed with that?


#2

(a) Use the recording facility to create the workflow
(b) make the necessary changes to suite your requirements like no of rows etc…


#3

Sorry @skini76, can you once explain me the two points mentioned.


#4

(a) Hope you know the recording facility available in UiStudio, manually create a pivot & record the steps using recorder which will create the workflow to create Pivot.
(b) You may have to make some changes in this workflow, because your dataset may keep changing (ie no of rows).

If still not clear, refer the online tutorial on how to use the recording facility


#5

you can create a macro, run it