Multi Level Data in Sales data table

Hi Team,

I have got a new enhancement as below..need help in implementation

Current system is

Organization(Higher level)--> Country(Lower level)

Data is collected at item and country level

 

Item	Sales_Date	Country	Qty
33391C	1-Apr-16	RU	100

Enhancement is

Three new levels to be added(Org Segment,Sub segment,Industry segment)

Level Hierarchy is like below

and the data would be like below after enhancement-Qty allocation should be happened as per %allocation between Org segment and Industry segment but finally the qty would be collected at item country level from source.

How can we calculated qty at industry level if we are collecting at country level?