Calculation in pivot chart

[fashid]

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

[#2]

Hi ,

Use Like this (check Attached Application)

[fashid]

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

[#4 · Accepted solution]

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

[fashid]

Hi Vimlesh ,

I have attached the sample app.

Thanks for all the help.

Regards,

Nadeem