1 Reply Latest reply on Feb 14, 2018 3:03 AM by Aaron Evans

    Sales targets from defined dimension from filter

    Aaron Evans

      I have sales targets from multiple hierarchical reporting lines.

       

      In the attached packaged workbook, I have created an excel spreadsheet with the target for state and city.

       

      I want to be able to choose a state or city from the filters and return the associated target for either and if neither is selected then the total for highest reporting level, in this case the sum of all States.

       

      in my live workbook, I have 3 levels of reporting lines.

       

      Regards

       

      aaron