Hi

I was wondering if anyone could help me:

I have created a pivot table using a OLAP Cube and now want to reference to
it. Now by simply typing "=" and then onto the cell the formula produced is:

=GETPIVOTDATA("[Measures].[Sum Of GoodsValueInBase]",'Pivot Month
Cube'!$A$3,"[AccountNumber]","[AccountNumber].[All].[7800]","[TransactionDate]","[TransactionDate].[All].[2008].
[April]","[AccountCostCentre]","[AccountCostCentre].[All].[RIC]")

Now this works but what i want to do is instead of it being [April] which is
typed in i want to reference this part of the field item to a cell which
contains the word "April" so that when i simply change the month in that cell
(lets say for argument sake its in A3) all the formula's will change to say
"May" and so i dont have to change each formula.

Thanks.

Replace that part of the formula with a cell reference. For example:

=GETPIVOTDATA("[Measures].[Sum Of GoodsValueInBase]",'Pivot Month
Cube'!$A$3,"[AccountNumber]","[AccountNumber].[All].[7800]","[TransactionDate]","[TransactionDate].[All].[2008].
[" & A2 & "]","[AccountCostCentre]","[AccountCostCentre].[All].[RIC]")



Bazy2k wrote:
Hi

I was wondering if anyone could help me:

I have created a pivot table using a OLAP Cube and now want to reference to
it. Now by simply typing "=" and then onto the cell the formula produced is:

=GETPIVOTDATA("[Measures].[Sum Of GoodsValueInBase]",'Pivot Month
Cube'!$A$3,"[AccountNumber]","[AccountNumber].[All].[7800]","[TransactionDate]","[TransactionDate].[All].[2008].
[April]","[AccountCostCentre]","[AccountCostCentre].[All].[RIC]")

Now this works but what i want to do is instead of it being [April] which is
typed in i want to reference this part of the field item to a cell which
contains the word "April" so that when i simply change the month in that cell
(lets say for argument sake its in A3) all the formula's will change to say
"May" and so i dont have to change each formula.

Thanks.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html