Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I have a calculation to implement in pivot chart .
In the last Column of the pivot i need to calculate the reciprocity ratio in 2015 - reciprocity ratio in 2014.
The reciprocity ratio is calculated by the expression =Column(1)/Column(2)
The problem is cannot calculate it using column function.
I know i can write another expression for that but is it possible to get it with the column function.
I am attaching a screenshot of the pivot table.
Thanks &Regards,
Nadeem
Dear,
I don't think that in running time you can substract one column from another column (because that is not exit in reality)
You can do like this ,
i am attaching file.
may be help this.
Regards
Vimlesh
Hi ,
Use Like this (check Attached Application)
Hi,
Thanks for replying vimlesh.
But I do not want like that .It should stay in the same format as i have attached in the screenshot.
That is the issue i am facing .
And also how do i calculate the last column ie recirprocity ratio
Regards,
Nadeem
Dear,
I don't think that in running time you can substract one column from another column (because that is not exit in reality)
You can do like this ,
i am attaching file.
may be help this.
Regards
Vimlesh
Hi Vimlesh ,
I have attached the sample app.
Thanks for all the help.
Regards,
Nadeem