Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
There is set of data that loaded into the data loader as shown below
order npo. | revenue element | revenue | Header 4 |
---|---|---|---|
Ord1 | material | 240 | |
ord1 | labour | 100 | |
ord1 | others | 30 | |
ord2 | material | 300 | |
ord2 | labour | 250 | |
ord2 | others | 120 |
.Now i want to show this in table chart...so for each order i want the total revenue...that is sum of all the material labour and others revenue...its not accepting the sum function...is there any function that i can use to get the required output..
please do let me know how to proceed.
Hi,
have you tried to create table chart with dimension field Order npo. and measure field using :
sum( {<[revenue element]= {'material', 'others'}>} revenue)?
BR
Martin
try with this expression?
=sum(Total <Revenue Element> Revenue)
or
=sum(All Revenue)
HI,
Try like this using set analysis
=sum(Total <[order npo.]> Revenue)
Hope this helps you.
Regards,
jagan.
From looking at the formatting of your table - it looks like [revenue] might not be stored as numeric - which would explain why the sum function isn't working.
Perhaps try the NUM function around the [revenue] field in your load script