Pivot Table with Data Model Connection - getpivotdata #REF error

N

Nirmalya Choudhury

I have a pivot table that is connected to a data model as the data source for the pivot table. The data model is connected to a SQL Server.

I am using the data in the pivot table to populate a dashboard where I am using the getpivotdata function.

The problem with getpivotdata I am facing is that the arguments in the getpivotdata are referencing the data table in the data model

e.g.


=GETPIVOTDATA ("[Measures].[Count of Activity Type]",'DD View Pivots'!$A$3,

"[v_rpt_ActivitySummary].[Area (Regarding)]","[v_rpt_ActivitySummary].[Area (Regarding)].&[United States]",

"[v_rpt_ActivitySummary].[Note2]","[v_rpt_ActivitySummary].[Note2].&[Calls]",

"[v_rpt_ActivitySummary].[Week]","[v_rpt_ActivitySummary].[Week].&[This Week]")



When I try to change the item reference to certain cells in my output dashboard I get a #REF error.

e.g.

=GETPIVOTDATA ("[Measures].[Count of Activity Type]",'DD View Pivots'!$A$3,

"[v_rpt_ActivitySummary].[Area (Regarding)]",G$2

"[v_rpt_ActivitySummary].[Note2]",$C5,

"[v_rpt_ActivitySummary].[Week]",$D7) will give me a #REF error.


I would like to change the Items in my arguments into cell references.

Is there any way to fix this reference error?


Thanks,
Nirmalya.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Doughnut Chart linked with the slicer in the pivot table 0
GETPIVOTDATA #REF! error XL2003/2010 1
Dealing with a Pivot Table (when I don't want to) 0
Pivot Table GETPIVOTDATA 2
Use cell_ref in place of an item in get pivot data function 2
=GETPIVOTDATA 0
Pivot Table Data Aggregation 0

Top