Pivot find and replace

[sahilkh18]

Hello

I need some help with a few pivots I am creating using vba.

I'm facing the following issues with my pivots:

1) Not being able to sort in descending order basis the values in the grand total. I have tried using the recorded code as well as written code on my own, but it does not seem to work
2) I want to replace certain values within the pivots. But I can't be sure of the position of these values. I think find and replace would work, but I am not sure on how to put them in the code.

code is in the excel file. I can't attach the data, since its confidential. I have attached the pivot without the source, to show my problem.

Please help.

 

[mole999]

I don't think you can replace data in the pivot, that has to be the source (stand to be corrected)

what is the data you want to sort, how is it formatted, what type