I am creating Pivot Table from two Sources.
- Excel Worksheet It Self.
- SQL Server Connection - Using Pivot Table.
I am able to get both the pivot table but not able get the source of SQL server pivot table.
the simple pivot table from the worksheet provides the details regarding pivot table but not able to find DataSource of SQL Query pivot table.
I am attaching a sample file so you can look at the issue.
Sample Pivot Table.zip (12.7 KB)