locked
Power Pivot - Dynamic reference to result display RRS feed

  • Question

  • Hello,

    I get the following result display of a power pivot:

    =GETPIVOTDATA("[Measures].[Sum of No of Products SUM]";$AH$15;"[Table1].[Departure Week]";"[Table1].[Departure Week].&[201436]";"[Table1].[Line Code]";"[Table1].[Line Code].&[OSLKEL]")

    All I need is a dynamic reference to the pivot result where instead of [201436] I link to another excel cell (where the entry is 201436) in the formula.

    What I have in mind is a result like this (example take cell A1):

    =GETPIVOTDATA("[Measures].[Sum of No of Products SUM]";$AH$15;"[Table1].[Departure Week]";"[Table1].[Departure Week].&A1";"[Table1].[Line Code]";"[Table1].[Line Code].&[OSLKEL]")

    I played a little bit around and could not find the correct statement.

    Thanks for your help!

    Friday, April 10, 2015 1:42 PM

Answers

  • It works like this: ["&A1&"]

    Imke

    • Proposed as answer by Michael Amadi Saturday, April 11, 2015 8:07 AM
    • Marked as answer by Michael Amadi Saturday, April 18, 2015 11:37 PM
    Friday, April 10, 2015 4:12 PM
    Answerer

All replies