In the file attached, I have constructed an example of the data i am working with.
The data table gets fed into a pivot table that splits the branches into two groups. Each have a volume, rate and benchmark.
However, when I plot the chart (as shown in the file) the benchmark shows up twice on the data table underneath the graph. I would like to get rid of one of these entries, i.e. just have one benchmark show in the data table underneath the graph.
Could anyone please help?