1 Reply Latest reply on Nov 19, 2012 10:06 AM by Tracy Rodgers

    Creating Hierarchies for Measures - Workaround?

    Robert Rama

      From what I can tell, you cannot create hierarchies for measures although I understand that is a higher ranked idea according to Alex Kerin.

       

      I'm wondering if there's a workaround to this?

       

      Basically, I'm trying to create a dashboard of an income statement across departments.  I'd like to be able to drill through both the departments (dimensions) and income statement line items (measures).

       

      Is there any workaround for this?

       

      Or would I be relegated to creating 2 views - one that has departments as the hierarchied dimensions and the other with the income statement line items as the hierarchied dimensions?

       

      Any advice would be greatly appreciated.