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.
Still struggling with this one, I really don't want to use parameters as they can not filter at reporting levels