This is the table. In the Zone column, there are different values like I mentioned before.
For example Zone: Brooklyn, NewYork, NewHaven,Queens, Woodburry
Network: BBC,ANC, NBC,ANC,WAS
I want the derive values from the sub column and get new values based on the formula NewYork1 is equal to NewYork+Queens
For example, the value in the Network column ANC for NewYork is 10 and the value in the Network column ANC for Queens is 15. I wanted to show that Newyork1=25 in a new column.
These are actual data in one table. I want to be able to add AEC in Hudson and MMC in Hudson to equal to AEC1. The new value would be 51603+14879 in a new column. I have to do this for every zone and the formulas are all different.
My approach is to do one zone at a time. I separate the Hudson and Bayonne zones in to different views. From there, I guess I have to some how add the subs together.
Please let me know if this make more sense and if you have any idea.