Thanks MarMo. This helped me create the Pivot Table from the existing code.
However, I'm looking for Pivot table created from a table which has been added to datamodel. This is needed to get distinct count as option in the Value Field settings.
PFA for expected output for ready reference in the sheet " Backlog_Summary(Expected) "
Also, I learnt that, we need to create a connection to use the table as datamodel. I got the code from the attached excel (Movies.xlsm) which is working as expected. Run the function CreateBasicModelPivot in Module2
However, if I run the same code in my file, I get the Runtime error, Catastrophic error. Here the code that is causing the error:
Appreciate any help in fixing the same.
Thanks,
Vinod Krishna
Bookmarks