working on creating some charts for operator X
i have 3 sites, all 3 sites have 3 sectors
site one is having 4 layers in each sector, L800,L1800,L2100 and L2600
site two is having 2 layers in each sector, L800 and L1800
site three is having one layer in sector, L800
site four is having 2 layers in each sector L800 and L2600
unique dimension for sites is sector ID, so sector id site 1-S1, site 1-S2, site 1-S3 and so on and on.
i want to create a calculated field so that i would have in same row this
site , sector ID, band combination, i.e. site 1, site 1-S1, L800 + L1800 + L2100 + L2600.
here is excel attached with this data. in excel you can see in sheet 'what i have' what data i really have and in sheet 'what i would want' you can see what i would like to data to look like
thanks in advance
Danijel
