Saturday, April 28, 2012 2:11 PM
could you please help, whether Pivot Table drop down function can be used programatically?
I mean, I have for example 3 items from a hierarchy in a cell, MemberA, MemberB, MemberC, and if I run a code, Pivot Table drop down appears and helps in showing selection.
Monday, April 30, 2012 2:59 AMModerator
Currently, it seems that there is no API for PowerPivot, I would recommend you to submit a feedback to Microsoft Connect at this link at this linkhttps://connect.microsoft.com/SQLServer/Feedback
TechNet Community Support
Sunday, July 29, 2012 10:09 PM
I used the above link and got the following answer:
This issue is not a bug, please use the MSDN forums to get questions answered : http://social.msdn.microsoft.com/Forums/en-US/exceldev/threads
I will close this bug as won't fix since there is no item to fix on our side. There are many excel OM functions available.
Please help how I can proceed with the next step, thanks
Saturday, August 04, 2012 10:37 PMModerator
stoneclub, can you provide a link to the Connect item you reported, just so those interested in this issue in the future can find it?
Regarding the functionality you're looking for, have you tried the Filter List feature of OLAP PivotTable Extensions? It lets you copy and paste in a list of member names from your clipboard and it will search the hierarchy for those members, no matter what level they're on, and select them for you.
Your question was how to do this programmatically. If you want to follow my code in that project but rewrite it in VBA, it's not a trivial amount of code, but it can be done. If you do attempt to write this in VBA yourself, if you know the MDX unique name for the members you're filtering to, it's much easier. Let us know if that add-in works for you or if you have to write this in VBA.
Sunday, December 16, 2012 1:28 PM
Please find the link to connect item below:
I know about the pivot extension, however it is not user friendly.