GETPIVOTDATA with Date

[Raeven]

I could not reconcile GETPIVOTDATA with a date format criterion, so
changed the dates (I only need the month) to text, i.e., Nov 03.
However, this does not work, even when I only try to retrieve the No
03 data:

=GETPIVOTDATA('Roll-up Pivot'!$A$2,"'Nov 03'")

It works like this:

=GETPIVOTDATA('Roll-up Pivot'!$A$2,"Hours Enrg E")

but when I try to add the 'Nov 03' criterion, it gives a REF# error.

A second method that would solve this same problem would be if I coul
us a range criterion in GETPIVOTDATA. The original date format i
actully a number: 31128 (ymmdd). If I could retrieve the range of dat
between 31101 and 31130, that would work, too.

Lastly, it would also work if I could inlude several criterion from th
same category. For example, 31107, 31114, 31121, 31128, which are th
week-ending dates I need.

Any suggestions?

Thanks,
Stephani

 

[Debra Dalgleish]

To include both criteria, enclose each in single quotes:

=GETPIVOTDATA('Roll-up Pivot'!$A$2,"'Hours Enrg E' 'Nov 03'")

Or, to refer to the contents of a cell:

=GETPIVOTDATA('Roll-up Pivot'!$A$2,F4 & " " & G3)