What is the difference between "Create Pivot Table Workbook" & Create Pivot Table"?

[sobin_paul (SP)]

when I execute a “Create Pivot Table Workbook,” I see only the Pivot structure created.

But when I create “Create Pivot Table”, providing all the field info, I get a complete Pivot Table, which is beneficial.

Is it possible to use both together? I tried with Excel Process Scope → Create Pivot Table Workbook → Create Pivot Table but was unsuccessful (See Screen capture)

So, what is the purpose of “Create Pivot Table Workbook”? Explanation with an example will be appreciated?

[Anil_G (Anil Gorthi)]

@sobin_paul

Both serve same purpose..

In the second one you have added the fields but in the first one you have not added the fields ..so only structure is seen..please add the fields ao you would see data as well

Cheers