Change sum value

[#1]

Hi guys,

I'm new in this forum and didn't find any answers about my problem.

My pivot table has an expression (Valor_total) that sum 3 diferent variables (VALOR_1, VALOR_2, VALOR_3). I have to modify manually some of these sum's(not each variable), there is no specific rules. What can I do to input this value in the sum expression?

Tks,
Leonardo

[#2]

I got you point.  But all I need is this table you sent me, the Sum Table should be like this:

NAME               SUM
AAA                    550
XXX                     3000

ZZZ                      2000
YYY                       1500

and table adjustment with

AAA           550

got it?

I'm not able to get this incremental adjustment, I only have the full value

[#3 · Accepted solution]

I think I get it. How about this? I did not rename the tables but there are three now: 1 with the original value; 1 with the original value and the adjusted value; 1 with only the adjusted value. I am heading home for the day. I think you have what you need to continue. You probably just need to experiment with how you want to display the data. The formulas for all the fields are in the Straight Table objects. You can alter the formulas as you see fit. Regards.

[#4]

Yeah, this way. Only that should be diferent

Adjustments:

load * inline [
Name, Adjustment
AAA, 50];

should be

Adjustments:

load * inline [
Name, Adjustment
AAA, 550];

And This 550 being a inputbox, and shown on the Sum Table as "550".Its something like thatAAA = SUM (ADJUSTMENT)
THE REST OF VARIABLES = V1+V2+V3Got it?This 550 i'll input manually. This 50 should not exists

[#5]

You got it. I'll have to put a conditional sum in order to have it. In this case AAA the sum will be diferent of the others cases. Your query is ok. Thanks a lot for the patience