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?
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.
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.
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.
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
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).
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.