I am trying to modify some VBA code that worked with pivot tables to work with
power pivot tables.
I am trying to get the count of the options available in a report filter and
with regular pivot tables used
I try to do the same thing with a PowerPivot that has the same structure as myActiveWorkbook.Worksheets("Sheet1").PivotTables(1).PageFields(1).PivotItems.count
previous pivot table. Do I need to change something to get the total count of
items in the Report Filter?
Any update on this post?
Madhan1234,
This is an old thread and not likely to get any responses. Why dont you create a fresh thread? You will get faster replies.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks