Hi Friends
I am Getting # REF Error in get pivot data formula for data model pivot. Please Help
=GETPIVOTDATA("[Measures].[Distinct Count of po_number]",$A$3,"[Range].[Company]",M4,"[Range].[purchaser_name]",L5)
Thanks
Hi Friends
I am Getting # REF Error in get pivot data formula for data model pivot. Please Help
=GETPIVOTDATA("[Measures].[Distinct Count of po_number]",$A$3,"[Range].[Company]",M4,"[Range].[purchaser_name]",L5)
Thanks
This is what you want
=GETPIVOTDATA("[Measures].[Distinct Count of po_number]",$A$3,"[Range].[Company]","[Range].[Company].&["&M$4&"]","[Range].[purchaser_name]","[Range].[purchaser_name].&["&$L5&"]")
the values in the cells are part of the expression, not separate parameters.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks