Forum Discussion
Hierarchy look up in matrix
Hi, I want to implement a hierarchy (Level 8- Level 1) in a matrix visual. These levels are the area name in a country like (territory->>district etc.) and want to show the sales amount. I have thes...
Anonymous Understood your requirement.
You need to understand the concept here, since you have selected 'Carolinas Area' the data is restricted to 'Carolinas Area' the sum up to the hierarchy will be the value available in 'Carolinas Area'.
Since you are showing the list in your matrix, why do u need a filter ? You can make the filter and the chart independent using 'Edit Interactions'. That way if someone selects the filter, your chart will not change.
Hope this helps 🙂