5 Replies Latest reply on May 22, 2014 2:44 PM by jaimie.stark

    Hierarchy across two data sources


      I've attached an example with a basic structure similar to my actual project. I have two sources from separate Excel workbooks and am trying to build a hierarchy using both sources. In the attached example I need to create a hierarchy to collapse/expand from Department->Business Area->Title, so the counts can be summarized at the Department level and the user can expand further to view Business Area and expand again to view Titles. I tried pulling Department in to the primary source through a calculated field, but then it ends up as a Measure that I can't use in a hierarchy. I saw several posts with a similar question but none seemed to quite address this specific scenario. Thank you!!