tablebox

[#1]

name	id	sal	bonuas	addvance
aaaa	1	12345	1222	111
bbbb	2	3223	5433	122334
cccc	3	3211	45567	122334
dddd	4	56788	556	456677
eeee	5	33334	4322	56788
ffff	6	54322	33445	23345
gggg	7	7654	3333	65433
kkkkk	8	322111	3345	223345
llllll	9	5432	12345	43332
nnnn	10	5682	7823	9783

i have load this table from exel

then i want another column which is Total sal. in this Total sal values shouid be ((sal+bonus)-advance)

name	id	sal	bonuas	addvance	Total sal
aaaa	1	12345	1222	111	sal+bonus-addvance
bbbb	2	3223	5433	122334
cccc	3	3211	45567	122334
dddd	4	56788	556	456677
eeee	5	33334	4322	56788
ffff	6	54322	33445	23345
gggg	7	7654	3333	65433
kkkkk	8	322111	3345	223345
llllll	9	5432	12345	43332
nnnn	10	5682	7823	9783

like this how i can get. where i should write the expression

[Clever_Anjos]

Use an object graph straight table

1) Add dimension name

2) Add Dimension id

3) Add expression sum(sal)

4) Add expression sum(bonuas)

5) Add expression sum(addvance)

6) Add expression rangesum(sal,bonuas,-addvance)

[maxgro]

see attachment (in a chart, not in tablebox)

[MarcoWedel]

Load name ,

          id,

          sal,

         bonus,

         advance,

         sal+bonus-advance as [total sal]

Form yoursource;

e