Need vba to do calculation by formula in AF,AG,AH after grand total

Dear expert

I have rawdata which contains pivot in different sheet i want do small calculation beside pivot after grandtotal ends

there are some continent names in column labels two towards total of MAP I want formula run by vba
(ASIA,AFRICA,AUSTRALIA) conversion point is 2.5
EUROPEAN converstion point is 8.0
NORTH AMERCIA&SOUTH AMERCIA converstion point is 6.0
Then second formula is difference CURRENCY VARIATION-GRANDTOTAL
Third formula is RAIO = DIFFERENCE/1.5

at end paste special value in pivot with formatting color.

find the attachment!! Need to solve urgently

Honestly this sample is unclear.
I am not sure WHERE you are trying to calculate any of your calculations OR what to do WITH the conversion point "formula" request as it is also unclear.

Can yo attach a sample workbook with the following adjustments? Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Sorry, I took a look at the sample and there was too much going on for me to understand what you wanted but I forgot to post that.
Can you make a more simple sample and make it clear what you are trying to do?

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Maybe :

Please Login or Register  to view this content.

You are welcome. Thanks for marking the thread as solved.


Regards