P PaulFogel123 Member Mar 3, 2015 #1 Hi Everyone, I am trying to create a Getpivotdata formula on the attached worksheet, but I just can't seem to get it right. What I'd like to do is get Paid Salaries, for example, for Jan-14. Can you enter the correct formula? Paul Attachments Pivot Table 1.xlsx Pivot Table 1.xlsx 73.9 KB · Views: 6
Hi Everyone, I am trying to create a Getpivotdata formula on the attached worksheet, but I just can't seem to get it right. What I'd like to do is get Paid Salaries, for example, for Jan-14. Can you enter the correct formula? Paul
wudixin96 Member Mar 3, 2015 #2 =GETPIVOTDATA("Sum of Jan-14",$A$3,"Mapping","Paid Salaries") is This ?
wudixin96 Member Mar 3, 2015 #3 drag the formula down and to right Attachments QQ20150303135827.jpg 250.1 KB · Views: 10
P PaulFogel123 Member Mar 3, 2015 #4 wudixin96 said: drag the formula down and to right Click to expand... You are awesome! Thank you so much. Paul
wudixin96 said: drag the formula down and to right Click to expand... You are awesome! Thank you so much. Paul