Area KPI vs Same area without worst cell

[justdream]

Dears,


Sometimes I need to prepare charts as below one
contains my network success rate Vs. My network success after removing top worst cell


Usually, what I do (as shown in below excel) is copy and paste my network data without this item
and give it a name like Network without Item A


Do you know faster/ smarter way to do this
as sometimes I need to do for several cells one by one

[justdream]

any helpful ideas please

[justdream]

Hi Dears,
No single idea, haven't you ever faced this before or seen some tools that could do it in few seconds..

[asifhaider919]

If you are working with Nokia and using Netact Reporting Suite, you can simply create the Working Sets to do your required task. (In New Netact Release Netact16 there is quick method of making working sets)

If you just have excel statistics, then you can import it in MS ACCESS and make some simple queries for it.