G
Guest
Excel is returning a "N/A" error for either of these
=GETPIVOTDATA('Detail Pivot'!$A$7,"Parts HP M12 total Sales$")
=GETPIVOTDATA('Detail Pivot'!$A$7,"Parts HP"&"M12 total Sales$")
I feel that having a 2 word row heading is causing the problem. How can I
fix this?
=GETPIVOTDATA('Detail Pivot'!$A$7,"Parts HP M12 total Sales$")
=GETPIVOTDATA('Detail Pivot'!$A$7,"Parts HP"&"M12 total Sales$")
I feel that having a 2 word row heading is causing the problem. How can I
fix this?