I have the following pull from a PowerPivot Pivot Table:
Is it possible to substitute the "'Top 10 Pivots'!$X$4" with some type of a reference in a cell? So instead of "'Top 10 Pivots'!$X$4" I'd want it to be something like $A5 which would contain the value 'Top 10 Pivots'!$X$4? Have to duplicate some Top 10 tables across business segments and would make it easier to just reference a cell.
Please Login or Register to view this content.
Thanks.
Better if you provided a sample sheet, but try:
=IF(ISBLANK($A11),"",GETPIVOTDATA("[Measures].["&G$66&"]",INDIRECT($A5),"[MonthOnlyDateTable].[Year]","[MonthOnlyDateTable].[Year].&["&PriorYear&"]","[MonthOnlyDateTable].[Fiscal Month]","[MonthOnlyDateTable].[Fiscal Month].&["&PYFiscalMonth&"]","[MasterData].[Product Group]","[MasterData].[Product Group].&["&$A11&"]"))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
That did it - Definitely need to learn the INDIRECT function better. Thanks and Repped!
You're welcome..
Advantages: very handy for things like that.
Disadvantages: volatile (recalculates everytime something changes... can make for poor performance) and (if referencing another workbook...) both workbooks MUST be open.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks