Lower level not sum to the next level.

[#1]

I have a table with various levels of data. But I can not do calculations with the lowest level to reach the higher levels, and can only show the values already reported these levels.

Example:

Region	Company	Category	Size	Distribution
SC	My			5
SC	My	Baby Clothes		4
SC	My	Baby Clothes	P	2
SC	My	Baby Clothes	M	1,4
SC	My	Baby Clothes	G	1,3

Thanks.

Tonial.

[#2]

Somebody help me?

[#3]

What do you want calculate? I don't understand.

[#4]

Region should be selected to show the value of the first row, value (5).

if you select the size M, I show the value of the 4 line, value (1,4).

[#5]

Size P, M, and G show the value "4". if it's correct you can use the follow:

Data:
LOAD * INLINE [
 Region, Company, Category, Size, Distribution
 SC, My, , , 5
 SC, My, Baby Clothes, , 4
 SC, My, Baby Clothes, P, 2
 SC, My, Baby Clothes, M, "1,4"
 SC, My, Baby Clothes, G, "1,3"
];
JOIN
LOAD Region, Company, Category, Distribution AS NewDistribution
RESIDENT Data
WHERE Size='';

Regard,