I'd like to know if it is possible to update/change a measure's formula created using the OLAP pivottable extensions using a macro.
I've created the following calculation:
calculation name: [Measures].[CO X AVG Filtered]
[Measures].[CO Y % AVG] > 40
,[Measures].[CO X AVG] /100
i would like now to create a macro that reads a specific cell (containing a number between 0 and 100, inputted by a user) and update the calculation formula with that number (in the example above, replace the 40 after the > sign with the number inputted
by the user).
Hope someone can help.
May 18, 2011 at 10:15 PM
This blog post has some good info on VBA and PivotTables:
That post was mentioned in my Additional Resources page, so there are some other good ones there:
Hope that helps.