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]

Can you provide more information? You can declare variables in QV and then set the value in for the variable via an input box. However, the variable value would be applied to all rows in the dataset.

[#3]

But I want to change some of this values, not all of them. Eg.

NAME       VALOR_TOTAL (V1+V2+V3)

XXX            3000
YYY            2000
ZZZ            1500
AAA            500

I wanna change the sum of AAA to 550  but keep the other values, and I don't wanna change V1,V2 and V3.

[#4]

I thought that was what you desired but I wanted to make sure. Are you trying to permanently adjust the value or run what if scenarios? The only thing I can think of off the top of my head is to load the adjustments either via an inline load or via an externally maintained data source (text file or Excel file). With these, you adjustments would be applied everytime you reloaded the QVW.

[#5]

is it possible? i don't want to change the original values, only the sum expression. can i make it via inline load? how do I do this?

[#6]

Here is the example. The level at which you track the data (i.e. if you wanted to track adjustments for a name and date) can be increased. The real limiting factor is how many rows you need to adjust and the fact that it is a manual process. It might be easier to track the data in Excel so that others could help maintain it and you are not constantly editing the script in the QVW.

[#7]

Yeah, almost that. but I want this sum table with all values of the original table, and i dont want this 'incremental adjustment' , but the "full adjustment". i want to type on this "adjustment table" the exact value that will be showed on the Pivot table. Can you get it? Sorry my English, I'm from Brazil, My english is not fully efective. hahahah

[#8]

I will modify 3 or 4 rows only. I can do this manually, no problem.

[#9]

I don't think I understand? Do you want the adjusted value to be 550? If that is the case, you can just change the value in the inline "Adjustment" table to be 550 and simplify the expression to be sum(Adjustment).

[#10]

I re-read your last post. I don't think you want to type the exact value. If you do this, you will have to enter a value for each row, regardless of whether it needs to be adjusted or not. The method I used sums up the existing data and then adds in your adjustment amount. This way, you only need to add data to the inline table for the rows that need to be adjusted. Using this method will also allow you to track the rows you have adjusted.