Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Somebody help me?
What do you want calculate? I don't understand.
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).
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,