locked
PowerPivot share the same filter among all the sheets RRS feed

  • Question

  • Hi all,

    I am new to power pivot.i have a requirement to show the pivot table and also the detailed data in the same sheet. i see in the pivot table we can right click and  drill down to view the detailed data, which opens in a  new sheet , but i want in the same sheet. 

    I also have another requirement to set the filters (slicers )selected on one sheet to be applicable to multiple sheets in the workbook, different information in all the sheets but uses the same parameter to populate the data...

    Please help me, thank you in advance.

    Hershey.

    Tuesday, July 3, 2012 6:44 PM

Answers

All replies

  • Hi,

    i blogged about how you can connect several pivot tables to the same filter/slicer
    http://gbrueckl.wordpress.com/2012/04/03/synchronizing-pivottable-filters/

    for your first requirement i'm afraid there is no solution, drill-throughs are always shown in a new sheet

    hth,
    gerhard


    - www.pmOne.com -

    • Proposed as answer by Raunak J Thursday, July 5, 2012 1:53 PM
    • Marked as answer by hershey28 Thursday, July 5, 2012 3:09 PM
    • Unmarked as answer by hershey28 Thursday, July 5, 2012 3:10 PM
    • Marked as answer by hershey28 Thursday, July 5, 2012 3:10 PM
    Wednesday, July 4, 2012 11:19 AM
    Answerer
  • Thank you for the  blog... That worked.

    I wish there is work around for drill throughs also.. 

    Thursday, July 5, 2012 3:13 PM