combition of filed valules to yield new field

[#1]

Hi,

i am sharing thes sample app

here in this app

1)i need list box with the third value as "TotalITem"

2) pivot chart wth the totalItem showing the sum of old and new items values.

help me out

[MK_QSL]

Add one more expression

SUM(TOTAL Value)

if you want 30 irrespective of selection, use SUM(All Value) as your expression..

[tresesco · Accepted solution]

values:
LOAD * INLINE [
    Item, Value
    old, 10
    new, 20
   
];

Load
'TotalItem' as Item,
Sum(Value) as Value
Resident values;

PFA

[#4]

Did not get your point. Can you please elaborate.

[#5]

Yes, it shows the result but we cant use that as a dimension right?

like i want that as a field in list box how to do that?

[MK_QSL]

Table1:

LOAD * INLINE [

    Item, Value

    old, 10

    new, 20

];

Concatenate

Load

'TotalItem' as Item, Sum(Value) as Value Resident Table1;