Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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