GetPivotData Data Model with Date as Criteria

reza_doang

Board Regular
Joined
May 31, 2010
Messages
185
Hi -

using PP Data model pivot is really new for me, i am trying to use getpivotdata below is the formula
=GETPIVOTDATA("[Measures].[Distinct Count of nama]",$K$2,"
#VALUE!
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

reza_doang

Board Regular
Joined
May 31, 2010
Messages
185
please ignore, found the answer already :)


=GETPIVOTDATA("[Measures].[Distinct Count of nama]",$L$2,"
#VALUE!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,032
Messages
5,526,353
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top