excel - Adding a string for a parameter in a GETPIVOTDATA function -
i'm hoping has solution this. have getpivotdata function works well, want add string formatted added getpivotdata . here example of getpivotdata function: =getpivotdata("sum of "&$o$62,$b$65,"class",b69,"scenario",$c$67,"capital/operating",$t$64) here string want add end of getpivotdata function. "project","(c0000000046) professional development","task","(300) certifications" project , task fields , "(c0000000046) professional development" , "(300) certifications" items want add getpivotdata function before evaluated. does know how make happen? updated here example file. if want add new parameter exiting formula: =getpivotdata("sum of " & $o$62, $b$65,"class", b69, "scenario", $c$67, "capital/operating", $t$64, _ "project","(c0000000046) professional development","task",&