I have the following formula
=GETPIVOTATA("Revenue",$A$4, "ClientName","Johnson Market","LOB","CL") . It happens to reference cell Z25 in my pivot table. Is there a formula that I could use that would return the result of the sum of the 12 columns prior (N25:Y25)? I need to keep the getpivotdata function as the reference and have to avoid replacing it with index and match and arrays.
=GETPIVOTATA("Revenue",$A$4, "ClientName","Johnson Market","LOB","CL") . It happens to reference cell Z25 in my pivot table. Is there a formula that I could use that would return the result of the sum of the 12 columns prior (N25:Y25)? I need to keep the getpivotdata function as the reference and have to avoid replacing it with index and match and arrays.
