2 Replies Latest reply on Apr 4, 2016 9:27 PM by kumar.c

    Heirarchy Questions

    joy rogers

      The attached image is what I have done. 

       

      -The heirarchy is parent company and sub companies.

      -those are the rows

      -the columns are our products

      - under the product name it has the average spend across all companies/subcompanies

       

       

      the idea is you can see how the companies compare against eachother. then expand the heirarchy to see how the subcompanies compare

       

       

      then you can expand and compare how the subcompanies are doing

       

       

      the issues

       

      1) I cant put a text box to say Average revenue above the row 1. It stops the heirarchy expansion from working.

       

      2.  it looks very excel pivot table esque. Any better ideas on how to run this viz would be appreciated.  I dont really want kpi arrow shapes.