GETPIVOTDATA function only returns zero's

S

Steven Cheng

I have a pivottable located on a worksheets that is pulling in a access table
and reorganizing it so that i have a subtotal on a particular field.

I am trying to pull the subtotal amount for Store and it is returning 0 as a
value. Here is hte function

=GETPIVOTDATA("dbAmount",$A$3,"dtTransactionDate",DATE(2008,1,25),"strStoreNumber","31137")

I don't know what is wrong with it. the subtotal amount for 31137 should be
make up of two line items for that particular date: row item 1 is null and
row item 2 = 1000. instead of returning 1000 for the subtotal, it returns 0.

Can someone please advise on this.
 

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

GETPIVOTDATA function returning 0 not #REF 0
sum of getpivotdata() 0
GETPIVOTDATA from OLAP cube - grouped field 0
GETPIVOTDATA #REF! error XL2003/2010 1
GETPIVOTDATA function 2
Need help creating a running subtotal 2
SubTotal function to return number of rows returns only zero 4
GETPIVOTDATA with date in referenced cell 1

Top