I have a very simple chart object and I want to create a new text box that shows a specific value from the chart (eg. the cell A1) multiplied by a standard Variable. How can I read-access the data from this cell of the chart in order to create an expression to the text box??
More specifically, I have loaded 5 dimension from a simple excel file. I have created a very simple chart pivot object on which i have selected on the dimension tab one dimension and on the expression tab i have selected an average function on another dimension from the total 5. The pivot chart object works fine. Now i want to calculate in text box an amount that makes use of a cell from the pivot chart object. How can i reach the value of this chart pivot object?? for example i want to calculate on the text box object the value of the cell [A,2] multiplied by a variable. Is there an function to get specific data from the pivot chart object making use of the object id for example??????
A2 is an expression that equals a value. So the expression is something like:
If you put this save value in a text object, and select 1 dimension, they should equal, then you can multiply this by a variable. If you have to get the actual coordinates from the pivot table, I've never seen this situation. Maybe someone else has and could help. Good luck!!
Yes I want exactly this. I want to get the data from actual coordinates from the pivot table(eg. A2) and use them on a calculation in a text box. I hope someone else knows about! Thank you very much mr Josh.
Yes they are fixed. The pivot table chart object is 4x2 and I want to get the four cells of the second column. Is there any way to do it making use of the function : str GetObjectField ([index [, objectid]]) ?????
It returns string but I want the number not the string and also I dont know how to use the index parameter in order to specify the cell [B,1] for example.