none
drilling down in pivot tables RRS feed

  • Question

  • After drilling down in a pivot table, is there a way to restrict or filter the number of fields returned so instead of the entire table I could select lets say 10 of the total 21 fields in the original data source?
    Wednesday, January 28, 2015 3:11 AM

All replies

  • Hi David,

    How do you want to achieve that requirement? Through code with excel object model or through UI in excel directly?

    If you want to do it through UI directly, I suggest that you should post it to Excel IT Pro Discussions forum.

    Base on this article below, it says that “You cannot drill down in flat hierarchies (such as hierarchies that show attributes of the same item but don’t provide data on a next level) or other hierarchies that don’t have data on multiple levels.”, is this that you want to achieve?

    # Drill into PivotTable data

    https://support.office.com/client/Drill-into-PivotTable-data-c1b11240-fc8f-4fdd-a697-629bf6f7ee0b

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Thursday, January 29, 2015 6:28 AM
    Moderator