issue regarding scenario

[#1]

if i have a tables like below

cid     amount          cid     amount            

101     50                 102    200

102     100                103    100

103     400               104     300

104     300               105     200

105     500

now chart has to show the total sales i.e. for 102 cid total sales is 100+200= 300 

like below

cid     amount

101    50

102    300

103    500

104    600

105    700

please help me

thanks in advance

[Anil_Babu_Samineni]

Take Straight table and use

Dimension - cid

Expression - Sum(amount)

[Siva_Sankar]

Hi Kenchala,

You must be missing the same column name , it is amount instead of amound

See code below:

T1:

Load * inline

[

cid,    amount              

101  ,  50              

102 ,    100              

103  ,  400          

104  ,  300              

105  ,  500

];

t2:

Load * Inline

[

cid, amount

102,200

103,100

104,300

105,200

];

find the attached example