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.