Create a macro to change pivotable

[harbors]

I have a pivotable that displays sales data (I have attached the worksheet)

The problem I am having is that I need to create 2 macros. 1 when you click the button it changes the data to shows the values as % of column total and the 2nd macro to show the data back to its original data (no calculation)

Can you tell me how to do this, this one is really driving me nuts.

I have attached the worksheet for you to see exactly what I am talking about

Thank you

[MarvinP]

Hi,

See the attached.

[harbors]

Thank you so much for the help. Could you tell me if you created the macro by clicking on "record macro" or by some other means?

[MarvinP]

Hi,..I.recorded.a.macro.and.then.edited.it.a.little.....Sorry.but.my.space.keyis.broken.

[harbors]

Can you tell me exactly how you recorded it? If possible step by step?

[Winon]

@MarvinP,

Hello Marvin,

I had a look at this before your post, and thought that it would require much more coding than what you came up with. Nice work!!!

I am using Office2007, and your code to calculate percentage totals return the monetary symbol, instead of displaying the result as actual %.

I have added this line to your code, which seems to "fix" the problem.

Please Login or Register  to view this content.

Would this only relate to a possible difference between Office 2010 and Office 2007?

Before I changed your code I have even tried to format all the cells in the Table to %, but that also did not solve the issue.