tag:blogger.com,1999:blog-1869924468172210809.post8493738964557925643..comments2011-05-13T20:30:57.653+01:00Comments on Not Just Numbers: Excel Tip: Using GETPIVOTDATA (part 1)Glen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-1869924468172210809.post-5917837555290135722011-05-13T20:30:57.653+01:002011-05-13T20:30:57.653+01:00Well spotted, thanks. This post has been read 1,93...Well spotted, thanks. This post has been read 1,935 times and you're the first to spot that. I'll change it now - or at least the first to tell me!Glen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-3489631078579908842011-05-13T20:05:07.223+01:002011-05-13T20:05:07.223+01:00The Salesman should, in fact, be "Matthew&quo...The Salesman should, in fact, be "Matthew" in order to return 15,813 as circled. =GETPIVOTDATA("Sum of Net",A3,"Salesman","Matthew","Region","South East")Anonymousnoreply@blogger.com