Implementing pervasive SQL pivot table for MS Excel queries

Asked By 30 points N/A Posted on -
qa-featured

How does one implement pervasive sql pivot table for MS Excel queries in order to ensure a cross-performance of data mining across the excel and database?

 
SHARE
Answered By 0 points N/A #147421

Implementing pervasive SQL pivot table for MS Excel queries

qa-featured

Hello Fern Bonnie ,

Hope that my message finds you well.

Follow the below steps:

–       Click the open door icon to see the “Import Data”.

Click the open door icon to see the Import Data

–       Select the range that you want from your Excel sheet.

Select the range from Excel sheet

–       The Microsoft Excel give you a lot of features to work with excel reports.

–       Also you can change the parameters as shown below.

Microsoft Excel give featues to work with excel reports

–       You can use the query with PivotTable, choose from the menu file then open the query that you just created to use it with PivotTables.

Created to use it with PivotTables

Hope this solution will help.

Kind regards,

Related Questions