Hi,
I'm trying to create chart <Image1> and <Image2> from below <data>.
<Data>
load * inline [
Date,D1,D2,D3,D4,Number,Sales
201101,Parent,Z,Rock,Sven,1,1000
201101,Parent,Z,Rock,Sven,2,2000
201101,Parent,Z,Rock,Sven,3,3000
201101,Parent,Z,Joan,Sven,4,4000
201101,Parent,Y,Rock,Sven,5,5000
201102,Parent,Z,Rock,Sven,6,6000
201102,Parent,Z,Ingrid,Sven,7,7000
201102,Parent,Z,Joan,Sven,8,8000
201102,Parent,Y,Rock,Sven,9,9000
201102,Parent,X,Rock,Sven,10,10000
201102,Parent,Z,Joan,Sven,11,11000
201102,Parent,Y,Rock,Sven,12,12000
201102,Parent,X,Rock,Sven,13,13000
201101,Child,Z,Helen,Joan,14,14000
201101,Child,Y,Helen,Rock,15,15000
201105,Child,Z,Helen,Rock,16,16000
201102,Child,Z,Binh,Rock,17,17000
201102,Child,A,Paul,Joan,18,18000
];
<Image 1>
-> Select None.
--------------------------------------------------
D2, D3, P_Number, P_Sales, C_Number, C_Sales
Z, Rock, 12, 12000, 33, 33000
Z, Joan, 23, 23000, 32, 32000
Z, Ingrid, 7, 7000, -, -
Y, Rock, 26, 26000, 15, 15000
X, Rock, 23, 23000, -, -
--------------------------------------------------
<Image 2>
-> Date 201101 Selected.
--------------------------------------------------
D2, D3, P_Number, P_Sales, C_Number, C_Sales
Z, Rock, 6, 6000, -, -
Z, Joan, 4, 4000, 14, 14000
Y, Rock, 5, 5000, 15, 15000
--------------------------------------------------
first, I separate <data> by D1 value. and create Parent/Child table and Concate those tables by D3/D4 value.
but when create <Image 1>, Child table value are missing.
Any thoughts or ideas greatly appreciated.
please help.
thanks