Multiple drill down through fields in pivot table

[#1]

Dear Qlikview Gurus,

We have a requirement where we have to show Sales in below format i.e there is hierarchy in fields. when user clicks vendor it should display business unit which is at multiple level and when business unit is clicked it should display base unit which is at multiple level, sales should be displayed at individual as well as at vendor and business unit by aggregating all levels.

Please help to achieve it ,we are trying in pivot table. Attached document is for reference and let me know if any details needed.

Fyi: all fields i.e vendor , business unit and base are in different tables.

Vendor                                    Sales

       Business Unit

             Base unit

TCS

  Marketing Sales

       CRM

       US Studio

       Tax

       PIT Stop

  Administrative Services

       CRM

       US Studio

       Tax

       PIT Stop

Wipro

     Marketing Sales

       CRM

       US Studio

       Tax

       PIT Stop

     Administrative Services

        CRM

        US Studio

        Tax

        PIT Stop

Thanks in advance.

Regards,

Kishore.

[jonathandienst · Accepted solution]

Create a drill group in the front end (Edit Groups from the Dimensions tab, or Groups from the Document Properties). The group should contain the fields Vendor, Business Unit, Base Unit. Then use the drill group as a dimension in the chart or table.

[#3]

Thank you