Chart graph help - Remove hierarchy total from chart graph
When creating a chart/graph with regards to a hierarchy list, the summary level is included in the chart...this is bad because 50% of every selection is the summary level. For example, in a 3 level hierarchy I want to be able to select the 2nd level and display the 3rd level pieces that make it up. Duramine in the pictures would be the 2nd level and should not be included in the chart, only '011 and 291 White' etc. should be shown. This is a product heirarchy. The other heirarchy in the module is location. I'd like to be able to select a product category (L2) and display the L3 products that make it up, and then select the locations or all locations for that information.
Hiding the summary lines or selecting levels to show does not work because then I cannot synchronize selection to the list. I want to be able to choose different L2s to display their L3 children and have it synch to that chart.
There is a working example of this chart that I did not build. I am trying to recreate that chart and find a solution to this issue for future charts. I'm surprised I wasn't able to find a solution to this in the community yet.