Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
see attachment (in a chart, not in tablebox)
Load name ,
id,
sal,
bonus,
advance,
sal+bonus-advance as [total sal]
Form yoursource;
e |