Calculate new records of a table.

[Anonymous]

Hello.

I have a table with records and I would like work with new recors, the results of some of them minus others.

For example, I want to show the result of orange section minus the green section. I do not know if this is better done in the data load script (add new records in the table), or work in the chart/pivot table expresions . The desired result would be to show the two sections indicated and the new section.

Can someone help me?

Thanks and regards.

[Digvijay_Singh]

Can  you share sample qvf and the expected output?

[Anonymous]

Finaly I did:

if([VW_TRV_FER.Producto]='Total larga distancia',Sum( {<[VW_TRV_FER.Producto] = {'Total larga distancia'}>} valor ) - Sum( {<[VW_TRV_FER.Producto] = {'AVE'}>} valor ))

It's works in single chart. But then I tryed put it in other with more restrictions, and it didnt work. The second  part passed to be negative in the chart (example: firts chart   12-2 = 10  ;  In second chart 12-2 = 12 and -2 ). So it maybe need more investigation.

Thanks and regards.