I have a pivot table with filters on multiple levels (say 1. Manager 2.Lead 3.Developer). When a manager is selected and filtered in 1.Manager column I would like to see the leads reporting to the selected Manager alone ( similar to the filter in excel ranges). But the Pivot shows all the values irrespective to the selected managers. 

Is there any option to do this?

• Moved by Lanlan HuangMicrosoft contingent staff 5 hours 29 minutes ago

Hi

This is the forum to discuss questions about Microsoft Excel develop. For your question is more about features for Excel, I will move this thread to the TechNet forum for Excel

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thank you for your understanding.

Best Regards

Try this C# Excel componentadd filter to your pivot table,this sample is for ordinary data:

Workbook workbook = new Workbook();
            workbook.LoadFromFile("DataTable.xlsx");

            Worksheet sheet = workbook.Worksheets[0];

            sheet.ListObjects.Create("Table", sheet.Range[1, 1, sheet.LastRow, sheet.LastColumn]);

            sheet.ListObjects[0].BuiltInTableStyle = TableBuiltInStyles.TableStyleLight9;

            workbook.SaveToFile("Filter.xlsx", ExcelVersion.Version2010);

ref:

http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data/How-to-filter-data-in-Excel-in-C.html