Grafana community provided the answer here: 1. effectively by using the "sumseries" function it works as expected.
grafana-sum-series
3925e8d270
grafana series, grafana series c, grafana series override, grafana series name, grafana series by tag, grafana series override regex not working, grafana series to rows, grafana series color, grafana series override regex variable, grafana series alias, grafana series wildcard