Getpivotdata from SQL

N

notcool

I created a Pivot Table from a SQL cube.
In the Pivot Table, my column dimension contained a hieracrchy :Fiscal
Year,Qtr,Month. In the Pivot Table, I chose to display Year 1 and Yr 2
Qtr 1 results. It shows Yr1-Qtr1-Jan to Mar results and Yr2-Qtr1-Jan to
Mar results. (See below)

I created 2 getpivotdata in 2 separate cells to extract Yr 1-Qtr1-Feb
and Yr 2 -Qtr1-Feb figures
It returns #Ref

If my Pivot Table only selects Yr 1 figure, ithe getpivotdata that
extracts Yr 1-Qtr1-Feb is OK. If PTable selects Yr 2, the other
getpivotdata is OK



Pivot Table looks like the following

Fiscal Year ---- Qtr ----Month
Yr 1 Yr 2
Qtr 1 Qtr 1
Jan --- Feb --- Mar Jan --- Feb --- Mar
100 -----200----300 100 -----200----300
 

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

drag formula down from columns that go acros 3
Pivot from multiple sheets 1
Pivot Table GETPIVOTDATA 2
Summing a non continuous range 7
How can count the number of cells that fulfill certain criteria in other cells 2
Reference page header to query parameters 2
assistance needed: transpose data from rows to columns 1
Macro start and finish date from rows 16

Top