Forum Discussion
Calculate Hierarchy Above Performance
Hello all, I am trying to set up some measures that work with my hierarchy and report filters to show performance for hierarchy levels above when filtered - eg I select a store and see their performa...
sturlaws
Resident Rockstar
Resident RockstarHi Anonymous,
could you share your report? Or create a sample report where you replicate the behaviour you are experiencing?
Cheers,
Sturla
Here is a link to a sample file. You will see that the graph visual only shows Store and Market when initially using just the filter pane to filter to store 9541, but when you select store 9541 in the matrix, the visual updates to show all three - Store, District, and Market.
Desired result is to have all three show up when simply using the Filter Pane to filter to a specific store as the finished report will not have a matrix.