Required sum of two pivot table data

[r_2]

Pls let me know in case we can add or subtract data from to different pivot of same field.
Ex:
I require to sum column B With column I & column C with J .

& with the results need to create another pivot table.

 

[sudipto3003]

hi,
you can do it with the help of "consolidate", go through the attach file. is it what you are looking for?

 

[r_2]

pls provide the steps for consolidation it.

 

[r_2]

& when i am selecting the data its taking as sheet!
if iam writing it as pivot it didn't consolidate the data & return the error , in the xls zone column is added with do code..pls provide the details to segregate that.

Thnx for quick reply

 

[Kyrre]

I am not sure if I understood the Q, however u could use the formula in another sheet if it was wrong answer.
U may update after adding new data.
Please let me know if it works as requested

 

[r_2]

hi,
you can do it with the help of "consolidate", go through the attach file. is it what you are looking for?

Pls provide the details of consolidation,when i am selecting the data its taking as sheet!
if iam writing it as pivot it didn't consolidate the data & return the error , in the xls zone column is added with do code..pls provide the details to segregate that.

 

[Kyrre]

Pls provide the details of consolidation,when i am selecting the data its taking as sheet!t.

Hi, I am sorry to say that I am not so good in english language, so I don`t understand you. Could u pls rewrite it in a bit more easy language? Consolidation , segregate and words like that mess up my understanding totally