locked
How to drill into detail in Pivot Table? RRS feed

  • Question

  • I'm trying to use Excel 2013 to provide Pivot Table with a capability to drill-down to detail from a Tabular Cube.  This Detailed report is like a the Orders Detail associated to the Order Header.  Say, the Order Header has the PivotTable with the Aggregations.  How can I drill into the details finding the make up of the Aggregations? OrderHeader (PivotTable)

    OrderID  OrderAggreTotal OrderDate
    1            $10.        2013/09/26
    2            $5.            2013/09/27

    OrderDetail
    OrderDate    OrderID        Qty        UnitPrice    Description
    2013/09/26    1            1        $6            AA battery
    2013/09/26    1            1        $1            bottle water
    2013/09/26    1            1        $1            bottle water
    2013/09/26    1            1        $1            bottle water
    2013/09/26    1            1        $1            bottle water
    2013/09/27    2            1        $2.5        Protein Bar
    2013/09/27    2            1        $2.5        Protein Bar

    -- IBM has jobs for USA employee to work oversea (India) and get their wages.


    • Edited by light_wt Tuesday, October 8, 2013 4:17 PM
    Tuesday, October 8, 2013 4:14 PM

Answers

  • there might be many different ways to do this.  I've just found one.  As a note to myself, double click on the excel cell which has the aggregate and a new sheet with the detail (entire row) will be shown.


    -- IBM has jobs for USA employee to work oversea (India) and get their wages.

    • Marked as answer by light_wt Tuesday, October 8, 2013 6:40 PM
    Tuesday, October 8, 2013 6:40 PM