How to create Pivot table with & without using Create Pivot Table actvity?

[ronanpeter]

You can use VB Code to do this.

Is there a way to create pivot tables based on business rules?

You could do it with VB Code. The attached is an example of invoking code on a simple table in an excel sheet to create a new worksheet with a simple Pivot Table based on a single column selection and single filter. You could adapt this on your data by changing the parameters where required. 'Create the excel objects to work on Dim excel As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook Dim ws As Microsoft.Office.Interop.Excel.Worksheet Dim p_ws As …